Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
no edit summary
==Options==
In the following table, all available options are listed. The Excel column indicates what are the preferred lists recommended options for data that is to be imported, processed with Excel or has been exported from ExcelOpen/Libre Office.
{| class="wikitable sortable" width="100%"
| {{Code|comma}}, {{Code|semicolon}}, {{Code|colon}}, {{Code|tab}}, {{Code|space}} or a ''single character''
| {{Code|comma}}
| {{Code|semicolon}}or {{Code|comma}}, depending on the region
|- valign="top"
| {{Code|header}}
| {{Code|no}}
| {{Code|no}}
|- valign="top"
| {{Code|allow}}
| Introduced with {{Mark|BaseX 9.7}}: In Excel, a value will be interpreted if it starts with the character -, +, =, @, TAB or CR. A regular expression can be specified to reject data that will be rendered differently than expected or that may be malicious (see https://owasp.org/www-community/attacks/CSV_Injection for more details).
| ''string''
| {{Code|no}}
| <code><nowiki>[^-+=@	 ].*|[-+]\d?(\.\d+)?</nowiki></code>
|}
=Changelog=
;Version 9.7
* Added: [[#Options|Options]]: <code>allow</code> option.
;Version 9.4
