ChartControlBase.ExportToXlsx(String, XlsxExportOptions, PrintSizeMode) Method

Exports a chart to the specified file using the specified options and size mode in the XLSX format.

Namespace: DevExpress.Xpf.Charts

Assembly: DevExpress.Xpf.Charts.v24.1.dll

NuGet Package: DevExpress.Wpf.Charts

Declaration

C#

public void ExportToXlsx(
    string filePath,
    XlsxExportOptions options,
    PrintSizeMode sizeMode
)

VB.NET

Public Sub ExportToXlsx(
    filePath As String,
    options As XlsxExportOptions,
    sizeMode As PrintSizeMode
)

Parameters

Name	Type	Description
filePath	String	The value defining the full path (including the file name and extension) where the XLSX file will be created.
options	XlsxExportOptions	An object storing the XLSX export options to be applied when a chart is exported.
sizeMode	PrintSizeMode	The value specifying which size mode the chart must use when the chart control is exported.

Remarks

To print the document immediately without invoking any dialogs, use the ChartControlBase.PrintDirect method.

To show the standard Print dialog, use the ChartControlBase.Print method. The dialog allows end-users to print the chart, select the printer (if required), specify the range of pages to print, the number of copies, etc.

To display the DevExpress Document Preview, use one of the following methods.

Method	Description
ChartControlBase.ShowPrintPreview	Creates the print document and displays the Print Preview of the document.
ChartControlBase.ShowPrintPreviewDialog	Creates the print document and displays the Print Preview of the document as a modal window.
ChartControlBase.ShowRibbonPrintPreview	Creates the print document and displays the Print Preview with the Ribbon toolbar of the document.
ChartControlBase.ShowRibbonPrintPreviewDialog	Creates the print document and displays the Print Preview with the Ribbon toolbar of the document as a modal window.

To export the chart, use the appropriate ExportTo~ method (e.g., ChartControlBase.ExportToHtml, ChartControlBase.ExportToPdf, etc.)

Important

The chart can be previewed, printed and exported only if the DXPrinting Library is available. Make sure you add a reference to the DevExpress.Xpf.Printing.v24.1 assembly.

Also note that chart export to PDF is available if the DevExpress.Pdf.Core library is available.