HeatmapControl.ExportToXls(Stream, XlsExportOptions) Method

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

Namespace: DevExpress.Xpf.Charts.Heatmap

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

NuGet Package: DevExpress.Wpf.Charts

Declaration

C#

public void ExportToXls(
    Stream stream,
    XlsExportOptions options
)

VB.NET

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

Parameters

Name	Type	Description
stream	Stream	The stream for output data.
options	XlsExportOptions	Export settings.

Remarks

The following example uses the ExportToXls 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.xls", FileMode.OpenOrCreate)) {
            XlsExportOptions exportOptions = new XlsExportOptions();
            exportOptions.DocumentOptions.Title = "Heatmap";
            heatmapControl.ExportToXls(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.xls", FileMode.OpenOrCreate)
        Dim exportOptions As XlsExportOptions = New XlsExportOptions()
        exportOptions.DocumentOptions.Title = "Heatmap"
        heatmapControl.ExportToXls(outputStream, exportOptions)
    End Using
End Sub