HierarchicalChartControlBase.ExportToXlsx(String, XlsxExportOptions) Method

Exports the control to an XLSX file.

Namespace: DevExpress.XtraTreeMap

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

NuGet Package: DevExpress.Win.TreeMap

Declaration

C#

public void ExportToXlsx(
    string filePath,
    XlsxExportOptions options = null
)

VB.NET

Public Sub ExportToXlsx(
    filePath As String,
    options As XlsxExportOptions = Nothing
)

Parameters

Name	Type	Description
filePath	String	A file path that includes the file name and extension.

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.v24.1 assembly.