Skip to main content
Tab

ASPxGridExporterBase.WriteXlsxToResponse(Boolean, XlsxExportOptionsEx) Method

Exports the grid’s data to a file in XLS format with the specified export settings, and writes it to the Response in binary format.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v24.1.dll

NuGet Package: DevExpress.Web

Declaration

public void WriteXlsxToResponse(
    bool saveAsFile,
    XlsxExportOptionsEx exportOptions
)

Parameters

Name Type Description
saveAsFile Boolean

true to display the File Download dialog; false to display the XLSX file with exported data within a page.

exportOptions XlsxExportOptionsEx

A XlsxExportOptionsEx object that provides export options.

Remarks

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.

ASPxGridViewExporter1.WriteXlsxToResponse(true, new XlsxExportOptionsEx() { ExportType = ExportType.WYSIWYG }); 
See Also