24K Design Studio :: Blog
Author:
Password:
Using PHP, how to generate UTF8 encoded CSV file for Excel.07 Jul, 2011
by David

As we know, there is a function in PHP called fputcsv that can transfer array into CSV line.

However, if you make a CSV file only with these CSV lines, containing UTF8 characters, the generated CSV file will became a chaos in Excel.

 

Solution example:

$fp = fopen("php://temp", 'r+');
fprintf($fp, c
+ Read more...
Tag:
PHP
Excel
UTF8
1 reply / 919 views.
Reply
View the latest 5 entries.
Tags and Labels
AddThis(1)apache(1)AS3(3)Awstats(1)C(2)C++(3)CentOS(7)CGI Wrapper(1)Collected(2)ColorBox(1)CSS(4)Cufon(1)cURL(1)digg(1)eCard(3)Ecommerce(1)
Excel(1)
Facebook(2)ffmpeg(1)Flash(2)flv(1)GeoIPfree(1)HTML(6)IE9(1)IIS(1)IP(1)iPad(1)iPhone(1)ISAPI(1)Java GUI(1)Java System(1)Java Tools(1)JavaScript(5)jQuery(1)Linux(1)Mockup Tools(1)MSSQL(1)MySQL(5)Nagios(1)new year(3)Online Order(1)openJDK(1)Performance(2)perl(1)PHP(15)POS Printer(1)ProFTPD(1)Regular Expression(1)Retina Display(1)RSS(1)Server(10)Social Media(1)subversion(1)suexec(1)technorati(1)Time GMT(2)Tomcat(1)Twitter(1)URL Rewrite(2)UTF8(2)Video Convertion(1)VS2005(1)Web Design(2)