ASPxGridExporterBase.WriteXlsToResponse(String, Boolean, XlsExportOptionsEx) Method

Exports the grid’s data to the specified 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

C#

public void WriteXlsToResponse(
    string fileName,
    bool saveAsFile,
    XlsExportOptionsEx exportOptions
)

VB.NET

Public Sub WriteXlsToResponse(
    fileName As String,
    saveAsFile As Boolean,
    exportOptions As XlsExportOptionsEx
)

Parameters

Name	Type	Description
fileName	String	A String value that specifies the target file name.
saveAsFile	Boolean	true to display the File Download dialog; false to display the XLS file with exported data within a page.
exportOptions	XlsExportOptionsEx	A XlsExportOptionsEx 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.

C#

ASPxGridViewExporter1.WriteXlsToResponse("test.xls", true, new XlsExportOptionsEx() { ExportMode = XlsExportMode.DifferentFiles });