LinkBase.ExportToXlsx(String) Method

Exports a report to the specified file path in XLSX format.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public void ExportToXlsx(
    string filePath
)

VB.NET

Public Sub ExportToXlsx(
    filePath As String
)

Parameters

Name	Type	Description
filePath	String	A String value, specifying the file name (including the full path) for the created XLSX file.

Remarks

Note

This method overwrites any files present at the specified path that have the same file name without any warnings.

Once the document export has started, it will run until the resulting document is complete and cannot be interrupted or canceled in the process.

The following two modes of Excel export are available.

• Data-Aware Export

  This export mode is optimized for subsequent data analysis within Microsoft Excel. Various data shaping options that are applied within the control are retained in the output XLS-XLSX documents (such as native Excel grouping, sorting and filtering settings, as well as improved support for Excel formulas).

  The LinkBase class does not support this export mode and to use the data-aware export, it is required to call the corresponding methods of specific controls (e.g., GridControl).

• WYSIWYG Export

  With this export mode, the layout of a control’s cells is retained in the resulting Excel documents while specific data shaping options may not be retained.

  This is the only export method that is supported by the LinkBase class.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportToXlsx(String) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-print-pivot-and-chart-controls/CS/WinformsExport/Form1.cs#L46

    CompositeLink compositeLink = CreateCompositeLink(pivotGridControl1, chartControl1);
    compositeLink.ExportToXlsx(saveFileDialog1.FileName);
}

VB.NET

winforms-print-pivot-and-chart-controls/VB/WinformsExport/Form1.vb#L45

    Dim compositeLink As CompositeLink = CreateCompositeLink(pivotGridControl1, chartControl1)
    compositeLink.ExportToXlsx(saveFileDialog1.FileName)
End If