You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I'm using this code and when I open the file with the default CSV handler, which like in several other machines happens to be Excel, I get garbage characters instead of my Unicode characters. Yet, the CSV is built correctly and I can see it if I save it before opening. This is a known issue for Excel, and the workaround is prepending the CSV with the BOM code, by changing your code at line #20 to data = '\uFEFF'; instead of just data='';. This way, any modern version of Excel (probably above 2003) opens the file correctly. Maybe you could consider integrating this change into your code.
Thank you!
The text was updated successfully, but these errors were encountered:
Hi, I'm using this code and when I open the file with the default CSV handler, which like in several other machines happens to be Excel, I get garbage characters instead of my Unicode characters. Yet, the CSV is built correctly and I can see it if I save it before opening. This is a known issue for Excel, and the workaround is prepending the CSV with the BOM code, by changing your code at line #20 to data = '\uFEFF'; instead of just data='';. This way, any modern version of Excel (probably above 2003) opens the file correctly. Maybe you could consider integrating this change into your code.
Thank you!
The text was updated successfully, but these errors were encountered: