Belphemur/vue-json-csv

"separator-excel=true" and "encoding=utf-8" prevent BOM to work

Maze-fr opened this issue · 3 comments

Hello,

I'm using version 1.2.10, and I have a strange behaviour....

When trying to export using separator-excel=true and encoding set to encoding=utf-8, then I have the encoding being set like without BOM.

As a workaround, I've set the delimiter to ";" and removed separator-excel=true.
I think it's probably an Excel problem more than a "vue-json-csv" problem, but I don't know...

So I hope that it will at least help some people having this issue.

Great work-around

Thanks a lot for this, saved my day !

I dig as deep as a could, and yes, it's an excel issue. I can't do anything about this ...
When I specific the separator, excel discard the encoding of the file.

https://stackoverflow.com/questions/20395699/sep-statement-breaks-utf8-bom-in-csv-file-which-is-generated-by-xsl