ASPxVerticalGrid.ExportXlsxToResponse(String, Boolean, XlsxExportOptions) Method

Exports the control’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.v24.1.dll

NuGet Package: DevExpress.Web

Declaration

C#

public void ExportXlsxToResponse(
    string fileName,
    bool saveAsFile,
    XlsxExportOptions exportOptions
)

VB.NET

Public Sub ExportXlsxToResponse(
    fileName As String,
    saveAsFile As Boolean,
    exportOptions As XlsxExportOptions
)

Parameters

Name	Type	Description
fileName	String	The target file’s full path (including the file name and extension).
saveAsFile	Boolean	true to display the Save As dialog; false to display the file with exported data within a page.
exportOptions	XlsxExportOptions	The export options.

Remarks

This method writes files to the response and do not write them to a storage (for example, a file system). The file name should not contain any path to a folder (for example, “C:\Work\Files\file.xxx”).

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).