ASPxGridView.ExportXlsxToResponse(XlsxExportOptionsEx) Method

Exports the control’s data in XLSX format with the specified export settings, and writes it to the response in binary format.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v23.2.dll

NuGet Package: DevExpress.Web

Declaration

C#

public void ExportXlsxToResponse(
    XlsxExportOptionsEx exportOptions
)

VB.NET

Public Sub ExportXlsxToResponse(
    exportOptions As XlsxExportOptionsEx
)

Parameters

Name	Type	Description
exportOptions	XlsxExportOptionsEx	The export options.

Remarks

This method writes files to the response and do not write them to a storage (for example, a file system).

C#

ASPxGridView1.ExportXlsxToResponse(new XlsxExportOptionsEx { ExportType = ExportType.WYSIWYG });

VB.NET

ASPxGridView1.ExportXlsxToResponse(New XlsxExportOptionsEx With {
    .ExportType = ExportType.WYSIWYG
})

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExportXlsxToResponse(XlsxExportOptionsEx) 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#

asp-net-web-forms-grid-export-images/CS/Export/Default.aspx.cs#L22

protected void btnXlsxExport_Click(object sender, EventArgs e) {
    Grid.ExportXlsxToResponse(new XlsxExportOptionsEx() { ExportType = ExportType.WYSIWYG });
}