GridControl.ExportToXlsx(String, XlsxExportOptions) Method

Exports the data displayed by the GridControl.DefaultView (the GridControl.MainView or the currently maximized detail View) to the specified file in XLSX (MS Excel 2007) format using the specified options.

Namespace: DevExpress.XtraGrid

Assembly: DevExpress.XtraGrid.v24.1.dll

NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation

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 object that specifies export customization options and events. In data-aware export mode, initialize the parameter with a XlsxExportOptionsEx object. In WYSIWYG export mode, initialize the parameter with a XlsxExportOptions object.

Remarks

See Export to XLS and XLSX Formats to learn more.

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-grid-customize-data-aware-export-output/CS/GridDataAwareExportCustomization/Form1.cs#L54

// Export the grid data to the XLSX format.
gridControl1.ExportToXlsx("grid-export.xlsx", options);
// Open the created document.

VB.NET

winforms-grid-customize-data-aware-export-output/VB/GridDataAwareExportCustomization/Form1.vb#L57

' Export the grid data to the XLSX format.
gridControl1.ExportToXlsx("grid-export.xlsx", options)
' Open the created document.