CsvOptions
Since v0.1.1
CSV export options
Properties
Section titled “Properties”| Property | Type | Description |
|---|---|---|
delimiter? | string | Field delimiter (default: ’,‘) |
newline? | string | Line separator (default: ‘\n’) |
quoteStrings? | boolean | Whether to quote strings containing special characters (default: true) |
bom? | boolean | Add UTF-8 BOM for Excel compatibility (default: false) |
escapeFormulas? | boolean | Neutralize spreadsheet formula injection (CWE-1236) by prefixing string values that start with =, +, -, @, TAB or CR with a single quote, so Excel / LibreOffice / Sheets render them as text instead of evaluating them (default: true). v3.5.0+ |
Property Details
Section titled “Property Details”escapeFormulas
Section titled “escapeFormulas”Neutralize spreadsheet formula injection (CWE-1236) by prefixing string
values that start with =, +, -, @, TAB or CR with a single quote,
so Excel / LibreOffice / Sheets render them as text instead of evaluating
them (default: true).
Set to false only when the exported data is fully trusted AND the file is
re-imported by a parser that must see the original characters.