Question

我用PHPExcel，把数据输出到excel并导出到本地，但每次都下载不到本地，出现一堆乱码，希望大神解答一下

$write = new PHPExcel_Writer_Excel5 ( $excel );ob_end_clean();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/vnd.ms-execl" );header ( "Content-Type:application/octet-stream" );header ( "Content-Type:application/download" );header ( 'Content-Disposition:attachment;filename="data.xls"' );header ( "Content-Transfer-Encoding:binary" );$write->save ( 'php://output' );
我已经找到了问题的所在原因：这个是ajax请求过去的，所以才会爆出这样的错误，实际上应该利用 location.href 跳转过去，就可以直接下载了！





Answer 1

如果对格式没有要求的话可以用file_put_contens;
如果一定要用excel的话，就把字符集编码调整一下，最好是GBK之类的