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

Comments

Popular posts from this blog

Removing The Index.Php File From Url Inward Codeigniter

What Are The Main Components of a Computer System

Delete Daily Doppler E-Mail Spam From An Iphone [Fix]