UTF-8 and gbk encoding for importing php files to Excel. Php imports to excel-support utf8 and gbk encoding php imports to excel garbled characters because utf8 encoding does not support all utf8 transcoding in the XP system, which perfectly solves the UTF-8 encoding case? Import phph php to excel-utf8 and gbk encoding supported
Php imports garbled characters into excel because utf8 encoding does not support all utf8 transcoding in the XP system.
UTF-8 encoding case
Header ("Content-Type: application/vnd. ms-excel; charsets = UTF-8 ");
Header ("Pragma: public ");
Header ("Expires: 0 ");
Header ("Cache-Control: must-revalidate, post-check = 0, pre-check = 0 ");
Header ("Content-Type: application/force-download ");
Header ("Content-Type: application/octet-stream ");
Header ("Content-Type: application/download ");
Header ("Content-Disposition: attachment?filename=11.xls ");
Header ("Content-Transfer-Encoding: binary ");
?>
$ Filename = "php import to excel-utf-8 encoding ";
$ Filename = iconv ("UTF-8", "gb2312", $ filename );
Echo $ filename;
?>
Gbk encoding case
Header ("Content-Type: application/vnd. ms-excel; charsets = UTF-8 ");
Header ("Pragma: public ");
Header ("Expires: 0 ");
Header ("Cache-Control: must-revalidate, post-check = 0, pre-check = 0 ");
Header ("Content-Type: application/force-download ");
Header ("Content-Type: application/octet-stream ");
Header ("Content-Type: application/download ");
Header ("Content-Disposition: attachment?filename=11.xls ");
Header ("Content-Transfer-Encoding: binary ");
?>
$ Filename = "php import to excel-utf-8 encoding ";
Echo $ filename;
?>
Download to excel when visiting the website
Cell differences
You can create a webpage using a table.
Php imports garbled characters to excel because utf8 encoding does not support all utf8 transcoding in the XP system. it perfectly solves the UTF-8 encoding case? Php h...