Add sep=; to beginning of csv file
Add sep=; to beginning of csv file
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'
}
}
}
This question has an accepted answers - jump to answer
Answers
I think this thread may show you how to insert a line at the beginning of the CSV.
Kevin