PHP教程：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=www.niutw.com.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=www.iiwnet.com.xls '); 
header('Content-Transfer-Encoding: binary '); 
?> 
<? 
$filename='php导入到excel-utf-8编码'; 
echo $filename; 
?>

访问网站的时候就下载到excel里面

要弄单元格区别的话

用table表格做网页的就可以了

更多：PHP教程

转载于:https://my.oschina.net/xixios/blog/83486