Skip to main content

ChartControl.ExportToXlsx(Stream, XlsxExportOptions) Method

Creates an XLSX document with a chart inserted as an image and sends it to a stream, with the specified options.

Namespace: DevExpress.XtraCharts

Assembly: DevExpress.XtraCharts.v24.1.UI.dll

NuGet Package: DevExpress.Win.Charts

Declaration

public void ExportToXlsx(
    Stream stream,
    XlsxExportOptions options = null
)

Parameters

Name Type Description
stream Stream

A Stream object to which the created document is exported.

Optional Parameters

Name Type Default Description
options XlsxExportOptions null

An XlsxExportOptions object, containing the options for the resulting XLSX file.

Remarks

To show the standard Print dialog, use the ChartControl.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 Print Preview use one of the following methods.

Method Description
ChartControl.ShowPrintPreview Creates the print document and displays the Print Preview of the document.
ChartControl.ShowRibbonPrintPreview Creates the print document and displays the Print Preview with the Ribbon toolbar of the document.

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

Important

Note that, exporting to raster and vector images is implemented by the Chart and does not require any library.

The chart can be previewed, printed and exported to other formats only if the Printing library is available. Make sure you add a reference to the DevExpress.XtraPrinting.v24.1 assembly.

Also note that chart export to PDF requires the DevExpress.Pdf.Core library to be available.

See Also