解决火狐及IE不能下载excel的问题

php php  1362 收藏

解决火狐及IE不能下载excel的问题

//按如下方式定义方法即可正确到处excel文件，火狐及IE通用

function create_xls($data,$filename='simple.xls'){

ini_set('max_execution_time', '0');

Vendor('PHPExcel.PHPExcel');

$filename=str_replace('.xls', '', $filename).'.xls';

$phpexcel = new PHPExcel();

$phpexcel->getProperties()

->setCreator("Maarten Balliauw")

->setLastModifiedBy("Maarten Balliauw")

->setTitle("Office 2007 XLSX Test Document")

->setSubject("Office 2007 XLSX Test Document")

->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")

->setKeywords("office 2007 openxml php")

->setCategory("Test result file");

$phpexcel->getActiveSheet()->fromArray($data);

$phpexcel->getActiveSheet()->setTitle('Sheet1');

$phpexcel->setActiveSheetIndex(0);

header('Pragma:public');

header('Content-Type:application/x-msexecl;name="'.$filename.'"');

header('Content-Disposition:inline;filename="'.$filename.'"');

$objwriter = PHPExcel_IOFactory::createWriter($phpexcel, 'Excel5');

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

exit;

}

自学php博客