php导入Excel文件的例子(支持utf8、gbk编码)
发布时间：2017-01-24 编辑：jiaochengji.com
本文分享一个php导入数据到excel文件中的例子，同时支持utf8和gbk两种编码，有兴趣的朋友研究下吧。
php导入到excel文件，且支持utf8和gbk两种编码。
php导入到excel乱码，原因在于utf8编码在xp系统不支持所有utf8编码，做一下转码就好了。
1，php导入excel文件，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;
?>
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;
?>
2，php导入excel文件，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;
?>
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实现即可。
您可能感兴趣的文章：
php导入Excel文件的例子(支持utf8、gbk编码)
php导出数据为execel文件的实例分享
PHP导出EXCEL的简单范例 使用phpexcel类库导出excel
PHP导入与导出Excel文件的方法
mysql中文乱码原因与解决方法
详细阐述PHP环境下如何将GBK编码转成UTF-8格式
如何把Excel导入mysql数据表的方法详解
解决php下载excel无法打开的问题
Mysql中文乱码完美解决方案汇总
mysql创建数据库时如何指定编码与排序规则
[关闭]