GridCsvExportOptions Interface
The options to apply on the CSV export.
Demos
Import
import { GridCsvExportOptions } from '@mui/x-data-grid-premium';
// or
import { GridCsvExportOptions } from '@mui/x-data-grid-pro';
// or
import { GridCsvExportOptions } from '@mui/x-data-grid';
Properties
| Name | Type | Default | Description |
|---|---|---|---|
| allColumns? | boolean | false | If true, the hidden columns will also be exported. |
| delimiter? | string | ',' | The character used to separate fields. |
| escapeFormulas? | boolean | true | If false, the formulas in the cells will not be escaped.It is not recommended to disable this option as it exposes the user to potential CSV injection attacks. See https://owasp.org/www-community/attacks/CSV_Injection for more information. |
| fields? | string[] | The columns exported. This should only be used if you want to restrict the columns exports. |
|
| fileName? | string | document.title |
The string used as the file name. |
| getRowsToExport? | (params: GridCsvGetRowsToExportParams) => GridRowId[] | Function that returns the list of row ids to export on the order they should be exported. | |
| includeColumnGroupsHeaders? | boolean | true | If true, the CSV will include the column groups. |
| includeHeaders? | boolean | true | If true, the CSV will include the column headers and column groups.Use includeColumnGroupsHeaders to control whether the column groups are included. |
| utf8WithBom? | boolean | false | If true, the UTF-8 Byte Order Mark (BOM) prefixes the exported file.This can allow Excel to automatically detect file encoding as UTF-8. |