PivotGridControl.ExportToXlsx(String, XlsxExportOptions) Method

Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public void ExportToXlsx(
    string filePath,
    XlsxExportOptions options
)

VB.NET

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

Parameters

Name	Type	Description
filePath	String	A string that specifies the full path to the file to which the data is exported.
options	XlsxExportOptions	An XlsxExportOptions object that contains export options.

Remarks

The ExportToXlsx method indirectly calls the PrintingSystemBase.ExportToXlsx method of the XtraPrinting Library. If this library is not available, the method does nothing. For details on the ExportToXlsx method, see the PrintingSystemBase.ExportToXlsx topic.

For general information on exporting data, see Exporting.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportToXlsx(String, XlsxExportOptions) 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-pivotgrid--customize-cells-in-the-exported-excel-document/CS/WinPivotExportCustomizeCell/Form1.cs#L34

if (filePath != "") {
    pivotGridControl1.ExportToXlsx(filePath, exportOptions);
}

VB.NET

winforms-pivotgrid--customize-cells-in-the-exported-excel-document/VB/WinPivotExportCustomizeCell/Form1.vb#L36

If filePath <> "" Then
    pivotGridControl1.ExportToXlsx(filePath, exportOptions)
End If