php匯入到excel-支援utf8和gbk兩種編碼
php匯入到excel亂碼是因為utf8編碼在xp系統不支援所有utf8編碼轉碼一下就完美解決了
utf-8編碼案例
header("Content-Type: application/vnd.ms-excel; charset=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匯入到excel-utf-8編碼";
$filename=iconv("utf-8", "gb2312", $filename);
echo $filename;
?>
gbk編碼案例
header("Content-Type: application/vnd.ms-excel; charset=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匯入到excel-utf-8編碼";
echo $filename;
?>
訪問網站的時候就下載到excel裡面
要弄儲存格區別的話
用table表格做網頁的就可以了
http://www.bkjia.com/PHPjc/508436.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/508436.htmlTechArticlephp匯入到excel-支援utf8和gbk兩種編碼 php匯入到excel亂碼是因為utf8編碼在xp系統不支援所有utf8編碼轉碼一下就完美解決了 utf-8編碼案例 ?php h...