编码问题,解决方法:
一、开头加上一句:
header("Content-Type:text/html;charset=GB2312");
同时把你页面中的“ $cellvalue=iconv("gbk","UTF-8",$content...”的utf-8也统一为GB2312试试!
二、也可改用下面办法,不用$Excelobj=new PHPExcel();对象,而是直接输出html格式(只是把扩展名改为.xsl),因为excel,word本身是很好的html编辑器,能直接解释html标签:
//如果是xsl,word等则更简单,只需直接在原来的php文件开头加上下面几句:
header("Content-Type: application/force-download");//提示下载,而不是直接打开!
if( $sExport == "excel"){
header("ContentType = application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=".$oTitle.".xls");
}
if( $sExport == "word"){
echo ("
");
header("ContentType = application/vnd.ms-word");//或试试 application/msword
header("Content-Disposition: attachment; filename=".$oTitle.".doc");
}
if( $sExport == "csv"){
header("ContentType = application/csv"); //图像image/jpeg",或image/*"
header("Content-Disposition: attachment; filename=".$oTitle.".csv");
}
//.....输出原来的php代码
取消
评论