php生成excel到服务器,phpoffice生成文件到服务器指定文件

原代码

/**

* 导出excel信息

* @param string $titles 导出的表格标题

* @param string $keys 需要导出的键名

* @param array $data 需要导出的数据

* @param string $file_name 导出的文件名称

*/

function export_excel($titles = '', $keys = '', $data = [], $file_name = '导出文件' )

{

$objPHPExcel = get_excel_obj($file_name);

$y = 1;

$s = 0;

$titles_arr = str2arr($titles);

foreach ($titles_arr as $k => $v) {

$objPHPExcel->setActiveSheetIndex($s)->setCellValue(string_from_column_index($k). $y, $v);

}

$keys_arr = str2arr($keys);

foreach ($data as $k => $v)

{

is_object($v) && $v = $v->toArray();

foreach ($v as $kk => $vv)

{

$num = array_search($kk, $keys_arr);

false !== $num && $objPHPExcel->setActiveSheetIndex($s)->setCellValue(string_from_column_index($num) . ($y + $k + 1), $vv );

}

}

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

$objWriter->save('php://output');

exit;

}

/**

* 获取excel

*/

function get_excel_obj($file_name = '导出文件')

{

set_time_limit(0);

vendor('phpoffice/phpexcel/Classes/PHPExcel');

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='.iconv("utf-8", "gb2312", $file_name).'.xlsx');

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

return new PHPExcel();

}

改代码

function export_excel_ceshi($titles = '', $keys = '', $data = [], $file_name = '导出文件' )

{

vendor('phpoffice/phpexcel/Classes/PHPExcel');

$objPHPExcel = new PHPExcel();

$y = 1;

$s = 0;

$titles_arr = str2arr($titles);

foreach ($titles_arr as $k => $v) {

$objPHPExcel->setActiveSheetIndex($s)->setCellValue(string_from_column_index($k) . $y, $v);

}

$keys_arr = str2arr($keys);

foreach ($data as $k => $v) {

is_object($v) && $v = $v->toArray();

foreach ($v as $kk => $vv) {

$num = array_search($kk, $keys_arr);

false !== $num && $objPHPExcel->setActiveSheetIndex($s)->setCellValue(string_from_column_index($num) . ($y + $k + 1), $vv);

}

}

$writer = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

$filename = date('YmdHis',time()).$file_name.'.xlsx';

$filename = iconv("utf-8","gb2312",$filename);

$writer->save('upload/file/'.$filename);

return $filename;

exit;

}

微信公众号开发的网页，首先要验证是否是微信打开，而导出excel则只能跳到其他浏览器下载。跳到其他浏览器，则会验证不是微信打开，所以下载失败。

解决办法是，先用微信内置浏览器生成excel文件，存到服务器指定文件夹，返回文件名，再跳转到其他浏览器下载。

所以就不用$objWriter->save('php://output');

改用$writer->save('upload/file/'.$filename);

文件名不要用中文，省的乱码，找不到文件