ASPxGridView.ExportXlsxToResponse(Boolean, 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.v24.2.dll

Declaration

C#

public void ExportXlsxToResponse(
    bool saveAsFile,
    XlsxExportOptionsEx exportOptions
)

VB.NET

Public Sub ExportXlsxToResponse(
    saveAsFile As Boolean,
    exportOptions As XlsxExportOptionsEx
)

Parameters

Name	Type	Description
saveAsFile	Boolean	true to display the Save As dialog; false to display the file with exported data within a page.
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).

If the saveAsFile parameter is set to true, the control invokes the “Save As” dialog. However, a browser settings can disable the control to show this dialog. For example, the control does not invoke the “Save As” dialog and automatically downloads a file to the download folder if the “Ask where to save each file before downloading” option is set to false.

If the saveAsFile parameter is set to false, the browser tries to open a file in a new tab. If it fails, the browser invokes the “Save As” dialog (or file downloading).