Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

HeatmapControl.ExportToXlsx(Stream, XlsxExportOptions) Method

Exports the Heatmap Control to a stream in XLSX format with the specified export settings.

Namespace: DevExpress.Xpf.Charts.Heatmap

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

NuGet Package: DevExpress.Wpf.Charts

#Declaration

public void ExportToXlsx(
    Stream stream,
    XlsxExportOptions options
)

#Parameters

Name Type Description
stream Stream

The stream for output data.

options XlsxExportOptions

Export settings.

#Remarks

The following example uses the ExportToXlsx method to export the Heatmap Control to a stream with the specified export settings:

<dxh:HeatmapControl x:Name="heatmapControl">
    <dxh:HeatmapControl.PrintOptions>
        <dxh:HeatmapPrintOptions SizeMode="ProportionalZoom" />
    </dxh:HeatmapControl.PrintOptions>
</dxh:HeatmapControl>
<dx:SimpleButton Click="SimpleButton_Click"/>
using DevExpress.XtraPrinting;
using System.IO;

    private void SimpleButton_Click(object sender, RoutedEventArgs e) {
        using (FileStream outputStream = File.Open("D:/Temp/Document.xlsx", FileMode.OpenOrCreate)) {
            XlsxExportOptions exportOptions = new XlsxExportOptions();
            exportOptions.DocumentOptions.Title = "Heatmap";
            heatmapControl.ExportToXlsx(outputStream, exportOptions);
        }
    }
See Also