HierarchicalChartControlBase.ExportToXls(String, XlsExportOptions) Method

Exports the control to an XLS file.

Namespace: DevExpress.XtraTreeMap

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

NuGet Package: DevExpress.Win.TreeMap

Declaration

C#

public void ExportToXls(
    string filePath,
    XlsExportOptions options = null
)

VB.NET

Public Sub ExportToXls(
    filePath As String,
    options As XlsExportOptions = Nothing
)

Parameters

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

Optional Parameters

Name	Type	Default	Description
options	XlsExportOptions	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.