Add sep=; to beginning of csv file

shunki

MS Excel has an option to add sep=(separator) at the start of the CSV to detect the separator used by the file.
Is there a way to add this line (eg. sep=; ) to the generated CSV?
I know that this silly and Excel specific but I have a request to do this.

Here is my CSV button:
{ title: 'inputs', extend: 'csv', fieldSeparator: ';', text: 'Download CSV', charset: 'UTF-8', className: 'btn-outline-primary', exportOptions: { modifier: { search: 'none' } } }

kthorngren

I think this thread may show you how to insert a line at the beginning of the CSV.

Kevin