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.v23.2.dll

NuGet Package: DevExpress.Wpf.Charts

Declaration

C#

public void ExportToXlsx(
    Stream stream,
    XlsxExportOptions options
)

VB.NET

Public Sub ExportToXlsx(
    stream As Stream,
    options As XlsxExportOptions
)

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:

XAML

<dxh:HeatmapControl x:Name="heatmapControl">
    <dxh:HeatmapControl.PrintOptions>
        <dxh:HeatmapPrintOptions SizeMode="ProportionalZoom" />
    </dxh:HeatmapControl.PrintOptions>
</dxh:HeatmapControl>
<dx:SimpleButton Click="SimpleButton_Click"/>

C#

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);
        }
    }

VB.NET

Imports DevExpress.XtraPrinting

    Private Sub SimpleButton_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
        Using outputStream As FileStream = File.Open("D:/Temp/Document.xlsx", FileMode.OpenOrCreate)
            Dim exportOptions As XlsxExportOptions = New XlsxExportOptions()
            exportOptions.DocumentOptions.Title = "Heatmap"
            heatmapControl.ExportToXlsx(outputStream, exportOptions)
        End Using
    End Sub