Configuration export

    Specifies options for exporting grid data.

    Type: Object

    When export is enabled, the grid is accompanied by an Export button that exports grid data to the required format. You can specify common options for exporting, as well as format specific ones. For details on exporting, refer to the Export article.

    View Demo

    Watch Video

    allowExportSelectedData

    Indicates whether to allow end users to export not only the data displayed in the grid, but the selected rows only.

    Type: Boolean
    Default Value: false

    When this option is set to true, the Selected rows item is added to the menu invoked when pressing the Export button. This allows end users to choose whether to export all the data presented in the grid or only the selected ones.

    DevExtreme DataGrid Exporting Selected Rows

    enabled

    Indicates if the export feature is enabled in the grid.

    Type: Boolean
    Default Value: false

    NOTE: Your application/site must have a reference to the jszip.js (jszip.js.min) library. This library is accessible within your DevExtreme Package.

    excelFilterEnabled

    Specifies whether to enable Excel filtering for the exported data in the resulting XLSX file.

    Type: Boolean
    Default Value: false

    excelWrapTextEnabled

    Specifies whether to enable word wrapping for the exported data in the resulting XLSX file.

    Type: Boolean
    Default Value: undefined

    When this option is not set, the value of the grid's wordWrapEnabled option is used.

    fileName

    Specifies a default name for the file to which grid data is exported.

    Type: String
    Default Value: 'DataGrid'

    proxyUrl

    Specifies the URL of the server-side proxy that streams the resulting file to the end user to enable export in IE8, IE9 and Safari browsers.

    Type: String
    Default Value: undefined

    Generally, exporting is performed using client-side API in browsers. However, the IE8, IE9 and Safari (integrated in Mac OS) browsers do not implement an API for saving files. In this instance, the dxDataGrid widget can POST the content to a server-side proxy, which will stream the file back to the end user. To enable this functionality, set the export | proxyUrl option to the proxy, which will stream the file to the end user. When implementing the proxy, take the following information into account.

    • Your proxy will receive a POST request with the following parameters in the request body: fileName, contentType (the MIME type of the file) and base64 (the base-64 encoded file content).
    • The proxy should return the decoded file with the "Content-Disposition" header set to attachment; filename="".

    The sample proxy implementation for ASPx-based and PHP-based web servers is presented in the Export article.

    texts

    Contains options that specify texts for the export-related commands and hints.

    Type: Object

    Use these options to provide custom texts for the export-related commands and hints or when localizing the grid.