ASPxGridExporterBase.WriteXlsxToResponse(XlsxExportOptions) Method

Exports the grid’s data to a file 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 WriteXlsxToResponse(
    XlsxExportOptions exportOptions
)

VB.NET

Public Sub WriteXlsxToResponse(
    exportOptions As XlsxExportOptions
)

Parameters

Name	Type	Description
exportOptions	XlsxExportOptions	A XlsxExportOptions object that provides export options.

Remarks

The WriteXlsxToResponse method exports data to a file whose name is specified by the ASPxGridViewExporter.FileName property.

Note

Before exporting a grid, the ASPxGridExporterBase component creates an export document on a server. Therefore, when you export a large amount of data to a server with limited memory, the OutOfMemoryException exception may appear.

C#

ASPxGridViewExporter1.WriteXlsxToResponse(new XlsxExportOptions() { ExportType = ExportType.WYSIWYG });