php導入到Excel 的 utf8、gbk 編碼

php導入到excel-支持utf8和gbk兩種編碼

php導入到excel亂碼是因為utf8編碼在xp系統不支持所有utf8編碼轉碼一下就完美解決了

utf-8編碼案例

<?php 
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編碼案例

<?php 
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表格做網頁的就可以了