php读取excelutf8,php导入到Excel的utf8、gbk编码_PHP教程

php导入到excel-支持utf8和gbk两种编码

php导入到excel乱码是因为utf8编码在xp系统不支持所有utf8编码转码一下就完美解决了

utf-8编码案例

header(“Content-Type: application/vnd.ms-excel; charset&＃61;UTF-8”);

header(“Pragma: public”);

header(“Expires: 0”);

header(“Cache-Control: must-revalidate, post-check&＃61;0, pre-check&＃61;0”);

header(“Content-Type: application/force-download”);

header(“Content-Type: application/octet-stream”);

header(“Content-Type: application/download”);

header(“Content-Disposition: attachment;filename&＃61;11.xls “);

header(“Content-Transfer-Encoding: binary “);

?>

$filename&＃61;”php导入到excel-utf-8编码”;

$filename&＃61;iconv(“utf-8”, “gb2312”, $filename);

echo $filename;

?>

gbk编码案例

header(“Content-Type: application/vnd.ms-excel; charset&＃61;UTF-8”);

header(“Pragma: public”);

header(“Expires: 0”);

header(“Cache-Control: must-revalidate, post-check&＃61;0, pre-check&＃61;0”);

header(“Content-Type: application/force-download”);

header(“Content-Type: application/octet-stream”);

header(“Content-Type: application/download”);

header(“Content-Disposition: attachment;filename&＃61;11.xls “);

header(“Content-Transfer-Encoding: binary “);

?>

$filename&＃61;”php导入到excel-utf-8编码”;

echo $filename;

?>

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

要弄单元格区别的话

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

www.bkjia.comtrueTechArticlephp导入到excel-支持utf8和gbk两种编码 php导入到excel乱码是因为utf8编码在xp系统不支持所有utf8编码转码一下就完美解决了 utf-8编码案例 ?php h…