Introduction to how to export excel with php and solve the problem of garbled characters

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=export_data.xls");
echo "Name" ."t";
echo "traditional"."t";
echo "blog"."t";
echo "n";
echo "jason"."t";
echo "@"."t" ;
echo "javaeye"."t";
?>

You can consider adding a character set to the header header("Content-type:application/vnd.ms-excel;charset=UTF-8");

Question: This only tells the browser what character set to choose for viewing. In the end, my requirement is to generate an xls file. Some friends suggest using iconv to transcode.

echo iconv("current encoding","GB18030","this blog comes from javaeye, by jason");

Question: In this way, the Chinese character encoding in the file is GB18030, but How does Excel know which encoding to use to open it? It can only rely entirely on the OS default. But if you do this when encountering Traditional BIG5, the code will still be garbled.

Finally, adopt the approach of phpMyAdmin and use HTMLExcel.

xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http: //www.w3.org/TR/REC-html40">








< ;td class=xl2216681 nowrap>Robbin can spit
1234
5678javaeye website< ;/td>

Copy the code

In this way, you can echo directly, There is no need for iconv transcoding, as long as the Content-type in HTML is set (UTF-8 is used here), of course the header still needs to be added:

header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=export_data.xls");

That's it That's it. Friends who are interested, please test it quickly and see if there is no longer a problem of garbled characters when exporting Chinese content to Excel? !