XtraReport.ExportToXlsx(String) Method
Exports a report to the specified file path in XLSX format.This method exports data in WYSIWYG mode. Certain controls (e.g., a GridControl) can be exported to XLS(XLSX) format in a faster data-aware export mode, optimized for subsequent analysis of data in MS Excel. To learn how to employ data-aware export, see Export to XLS and XLSX Formats.
Namespace: DevExpress.XtraReports.UI
Assembly: DevExpress.XtraReports.v19.2.dll
NuGet Package: DevExpress.Reporting.Core
Declaration
Parameters
| Name | Type | Description |
|---|---|---|
| path | String | A String which specifies the file name (including the full path) for the created XLSX file. |
Remarks
Once the document export has started, it will run until the resulting document is complete and cannot be interrupted or canceled in the process.
Use this method to export a report in XLSX format using its current XLSX-specific export options. These options are represented by the XlsxExportOptions object returned by the ExportOptions.Xlsx property of a report’s XtraReport.ExportOptions. This object provides additional properties intended to specify parameters of the resulting XLSX file. For a list of these options, and more information on using the ExportToXlsx method, refer to Export to XLSX.
Note
This method overwrites any files present at the specified path that have the same file name without warning.
If you want to ignore current export options of a report, and use your specific settings when a report is exported to XLSX, you should use the overloaded XtraReport.ExportToXlsx method with the options parameter.
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.