Workbook.ExportToPdf(String, PdfExportOptions, IEnumerable<String>) Method

SECURITY-RELATED CONSIDERATIONS

Using file paths sourced from untrusted input may expose unauthorized files or allow unintended file access. Always validate and normalize all external paths to prevent path manipulation.

Defines export options and exports the specified sheets to the file in PDF format.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Docs.v25.2.dll

NuGet Package : DevExpress.Document.Processor

csharp

public void ExportToPdf(
    string fileName,
    PdfExportOptions options,
    IEnumerable<string> sheetNames
)

Public Sub ExportToPdf(
    fileName As String,
    options As PdfExportOptions,
    sheetNames As IEnumerable(Of String)
)

Parameters

Name	Type	Description
fileName	String

The file name (including the full path) for the created PDF file.

| | options | PdfExportOptions |

Specifies export options.

| | sheetNames | IEnumerable<String> |

Lists the names of the sheets to be saved in PDF format.

Remarks

The default calculation mode for a Workbook is Manual. This mode implies that the Spreadsheet does not recalculate formulas before it generates a PDF document. Call the Workbook.Calculate or Workbook.CalculateFull method to calculate all formulas in the workbook before you export it to PDF.

The following code snippet loads the specified XLSX document and exports its Sheet1 and Sheet2 worksheets as a PDF file with the specified settings:

C#
VB.NET

csharp

Workbook workbook = new Workbook();
workbook.LoadDocument("BreakevenAnalysis.xlsx");

PdfExportOptions options = new PdfExportOptions();
options.DocumentOptions.Author = "John Doe";
options.DocumentOptions.Title = "Breakeven Analysis";
options.ImageQuality = PdfJpegImageQuality.Medium;
options.ExportBookmarks = false;

workbook.ExportToPdf("Exported_Document.pdf", options, new List<string>() { "Sheet1", "Sheet2" });

Dim workbook As New Workbook()
workbook.LoadDocument("BreakevenAnalysis.xlsx")

Dim options As New PdfExportOptions()
options.DocumentOptions.Author = "John Doe"
options.DocumentOptions.Title = "Breakeven Analysis"
options.ImageQuality = PdfJpegImageQuality.Medium
options.ExportBookmarks = False

workbook.ExportToPdf("Exported_Document.pdf", options, New List(Of String) From {"Sheet1", "Sheet2"})