ASPxGridExporterBase.WriteXlsToResponse() Method

Exports the grid’s data to a file in XLS format and writes it to the Response in binary format.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v20.2.dll

NuGet Package: DevExpress.Web

Declaration

C#

public void WriteXlsToResponse()

VB.NET

Public Sub WriteXlsToResponse

Remarks

The WriteXlsToResponse 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.WriteXlsToResponse(); 

Concept

• Custom Export

Related GitHub Examples

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

aspxgridview-how-to-export-dynamically-selected-grid-using-the-renderbrick-event-handler-e996/CS/Exporter/Default.aspx.cs#L64

    ASPxGridViewExporter1.GridViewID = SetGrid();
    ASPxGridViewExporter1.WriteXlsToResponse();
}

VB.NET

aspxgridview-how-to-export-dynamically-selected-grid-using-the-renderbrick-event-handler-e996/VB/Exporter/Default.aspx.vb#L54

    ASPxGridViewExporter1.GridViewID = SetGrid()
    ASPxGridViewExporter1.WriteXlsToResponse()
End Sub