HeatmapControl.ExportToXls(Stream, XlsExportOptions) Method

Creates an XLS document with the diagram inserted as an image and sends it to a stream.

Namespace: DevExpress.XtraCharts.Heatmap

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

NuGet Package: DevExpress.Win.Charts

Declaration

C#

public void ExportToXls(
    Stream stream,
    XlsExportOptions options = null
)

VB.NET

Public Sub ExportToXls(
    stream As Stream,
    options As XlsExportOptions = Nothing
)

Parameters

Name	Type	Description
stream	Stream	A Stream descendant class object to which the file should be sent.

Optional Parameters

Name	Type	Default	Description
options	XlsExportOptions	null	Contains settings that are applied to the exported document.

Remarks

To show the standard Print dialog, use the HeatmapControl.Print method. This dialog allows users to print the diagram, select the printer, specify the range of pages to print, the number of copies, and so on.

To display the DevExpress Print Preview, use one of the following methods:

Method	Description
HeatmapDiagramControl.ShowPrintPreview	Creates a print document and displays the Print Preview dialog.
HeatmapDiagramControl.ShowRibbonPrintPreview	Creates a print document and displays the Print Preview with the Ribbon toolbar.

To export the diagram, use one of the ExportTo~ methods (for example, call the HeatmapControl.ExportToPdf method to export the diagram to a PDF file).

Important

The diagram can be previewed, printed or exported to other formats only if the Printing library is available (except when you export to raster and vector images). Ensure you add a reference to the DevExpress.XtraPrinting.v24.1 assembly.

Note that the DevExpress.Pdf.Core library should be available to export the heatmap to PDF.