XtraReport.ExportToXlsx(Stream, XlsxExportOptions) Method

Exports a report to the specified stream in XLSX format. This method exports data in WYSIWYG mode.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v24.1.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

public void ExportToXlsx(
    Stream stream,
    XlsxExportOptions options = null
)

VB.NET

Public Sub ExportToXlsx(
    stream As Stream,
    options As XlsxExportOptions = Nothing
)

Parameters

Name	Type	Description
stream	Stream	A Stream for output data.

Optional Parameters

Name	Type	Default	Description
options	XlsxExportOptions	null	A XlsxExportOptions object that specifies the XLSX export options. You can omit this parameter to use the current report export options.

Remarks

Note

Once the document export has started, it runs to completion and you cannot interrupt or cancel it.

This method exports a report to a file in XLSX format with the specified XLSX export options.

If you do not specify export options, the method uses the current report export options. To access the report export options, use the XtraReport.ExportOptions.Xlsx notation.

Use the ExportToXlsxAsync(Stream, XlsxExportOptions, CancellationToken) method instead of ExportToXlsx to export a report asynchronously in a separate task.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ExportToXlsx(Stream, 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#

reporting-webforms-print-export-report-without-showing-a-preview/CS/T227361/Default.aspx.cs#L77

case "xlsx":
    report.ExportToXlsx(ms);
    break;

reporting-mvc-print-export-report-without-preview/CS/T569785/Controllers/HomeController.cs#L84

case "xlsx":
    report.ExportToXlsx(ms);
    break;

asp-net-mvc-grid-export-with-reports/CS/E4121/Controllers/HomeController.cs#L43

{
    report.ExportToXlsx(stream);

VB.NET

reporting-webforms-print-export-report-without-showing-a-preview/VB/T227361/Default.aspx.vb#L70

Case "xlsx"
    report.ExportToXlsx(ms)
Case "rtf"

reporting-mvc-print-export-report-without-preview/VB/T569785/Controllers/HomeController.vb#L74

Case "xlsx"
    report.ExportToXlsx(ms)
Case "rtf"

asp-net-mvc-grid-export-with-reports/VB/E4121VB/Controllers/HomeController.vb#L29

Using stream As MemoryStream = New MemoryStream()
    report.ExportToXlsx(stream)
    Dim disposition As String = If(saveAsFile, "attachment", "inline")