ChartControlBase.ExportToXls(String, XlsExportOptions) Method

Exports a chart to the specified file using the specified options in the XLS format.

Namespace: DevExpress.Xpf.Charts

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

NuGet Package: DevExpress.Wpf.Charts

Declaration

C#

public void ExportToXls(
    string filePath,
    XlsExportOptions options
)

VB.NET

Public Sub ExportToXls(
    filePath As String,
    options As XlsExportOptions
)

Parameters

Name	Type	Description
filePath	String	The value defining the full path (including the file name and extension) where the XLS file will be created.
options	XlsExportOptions	An object storing the XLS export options to be applied when a chart 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.2 assembly.

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