Solution To Output A Utf-8 Csv Inward Php That Excel Volition Read Properly
Excel doesn't back upward UTF-8. You accept to encode your UTF-8 text into UCS-2LE. It is real uncomplicated to alter the encoding inwards PHP. You tin purpose next PHP inbuilt percentage to covert encoding from utf8 to ucs-2le. mb_convert_encoding($output, 'UCS-2LE', 'UTF-8'); Open the CSV amongst excel, it volition display the particular characters properly. It saved a lot of fourth dimension for me at-least. Let me know if it helped for y'all guys equally well? Sumber http://developer-paradize.blogspot.com