ChartControl.ExportToXls(String) Method
Creates an XLS file with a chart inserted as an image.
Namespace: DevExpress.XtraCharts
Assembly: DevExpress.XtraCharts.v19.1.UI.dll
Declaration
Parameters
Name | Type | Description |
---|---|---|
filePath | String | A String which specifies the full path (including the file name and extension) to where the XLS file will be created. |
Remarks
If a file under the specified file path exists, the new file replaces it.
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.v19.1 assembly.
Also note that chart export to PDF requires the DevExpress.Pdf.Core library to be available.
Example
The following example demonstrates how to export a chart image inserted into XLS document to either a file or a stream.
Add a ChartControl object and populate it with data.
The Chart Control uses the DevExpress Printing Library to export a chart image. Add references to the following assemblies:
- DevExpress.XtraPrinting.19.1
- DevExpress.Printing.v19.1.Core
Use the ChartControl.IsPrintingAvailable property to check whether the chart can be exported.
To export the chart in the XLS format, use the ChartControl.ExportToXls method.
using System.IO;
// ...
if (chartControl1.IsPrintingAvailable){
// Exports to an XLS file.
chartControl1.ExportToXls("Output.xls");
// Exports to a stream as XLS.
FileStream xlsStream = new FileStream("Output.xls", FileMode.Create);
chartControl1.ExportToXls(xlsStream);
// ...
xlsStream.Close();
}