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

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.1.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

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

VB.NET

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#

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

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", options, New List(Of String) From {"Sheet1", "Sheet2"})