Using PHP, how to generate UTF8 encoded CSV file for Excel.
07 Jul 2011
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.
$fp = fopen("php://temp", 'r+');
(I got to know this idea from blog.foolbird.net/1517.html)
Reason: the 0xEF 0xBB 0xBF BOM header will let Excel know the correct encoding.