HierarchicalChartControlBase.ExportToXlsx(Stream, XlsxExportOptions) Method

Creates an XLSX document with the control inserted as an image and sends it to a stream.

Namespace: DevExpress.XtraTreeMap

Assembly: DevExpress.XtraTreeMap.v25.1.UI.dll

NuGet Package: DevExpress.Win.TreeMap

Declaration

C#

public void ExportToXlsx(
    Stream stream,
    XlsxExportOptions options = null
)

VB.NET

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

Parameters

Name	Type	Description
stream	Stream	A Stream object to which the created document is exported.

Optional Parameters

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

Remarks

To print the document immediately using the default printer without invoking any dialogs, use the HierarchicalChartControlBase.Print method.

To show the standard Print dialog, use the HierarchicalChartControlBase.ShowPrintDialog 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
HierarchicalChartControlBase.ShowPrintPreview	Creates the print document and displays the Print Preview of the document.
HierarchicalChartControlBase.ShowRibbonPrintPreview	Creates the print document and displays the Print Preview with the Ribbon toolbar of the document.

To export the treemap or sunburst, use the appropriate ExportTo method (e.g., HierarchicalChartControlBase.ExportToPdf, HierarchicalChartControlBase.ExportToImage, HierarchicalChartControlBase.ExportToXls, HierarchicalChartControlBase.ExportToXlsx, HierarchicalChartControlBase.ExportToRtf, HierarchicalChartControlBase.ExportToMht.)

Important

The chart can be previewed, printed and exported only if the Printing-Exporting Library is available. Make sure you add a reference to the DevExpress.XtraPrinting.v25.1 assembly.