export-csv
export-csv copied to clipboard
Force Excel to properly read UTF-8 characters
Hi,
By default Excel works with local character encoding, not utf-8 (for example windows-1250). But there seems to be a way to force it to use unicode. Simply add an extra meta tag in output HTML:
'<meta name=ProgId content=Excel.Sheet>' +
'<meta charset=utf-8>' +
'</head><body>' +
Forcing UTF-8 encoding (maybe via an option) would be appreciated