Workbook.ExportToPdf(String, PdfExportOptions, 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

Declaration

C#

public void ExportToPdf(
    string fileName,
    PdfExportOptions options,
    params string[] sheetNames
)

VB.NET

Public Sub ExportToPdf(
    fileName As String,
    options As PdfExportOptions,
    ParamArray sheetNames As 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	String[]	The names of the sheets to be saved in PDF format.

Remarks

The following code snippet loads the specified XLSX document and exports its first worksheet as a PDF file with the specified settings:

C#

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");

VB.NET

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")

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.