如何在浏览器中打开excel文件,
我不想要像强制下载对话框这样的东西,
我想在收件箱中单击excel文件时在浏览器中打开excel,就像在gmail中一样,它会显示浏览器本身,
同样的,如何在PHP中做.
解决方法:
include 'PHPExcel/IOFactory.php';
$inputFileType = 'Excel5';
$inputFileName = 'MyExcelFile.xls';
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');
exit;
编辑
如果您的Excel文件是Excel 2007(xlsx)或更高版本而不是Excel 2003(xls)或更早版本
include 'PHPExcel/IOFactory.php';
$inputFileType = 'Excel2007';
$inputFileName = 'MyExcelFile.xlsx';
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');
exit;
标签:php,com
来源: https://codeday.me/bug/20191001/1838057.html