// 前端代码
// 方法1
import fileDownload from 'js-file-download';// 需要安装 npm install js-file-download --save
axios({
method: 'post',
url: url,
data: postData,
responseType: 'arraybuffer',
}).then(function (res) {
// 方法1
let fileName = res.headers['content-disposition'].match(/filename=(\S*)/)[1];
fileDownload(res.data,fileName);
// 方法2
// let blob = new Blob([res.data], {type: "application/vnd.ms-excel"});
// let objectUrl = URL.createObjectURL(blob);
// window.location.href = objectUrl;
}).catch(function (error) {
});
// php代码
ob_clean();
//直接生成一个文件
$name = "入职人员个人信息表.xlsx";
$objWriter =\PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('myexchel.xlsx');
header('Content-Type:application/vnd.ms-excel');
header('Access-Control-Expose-Headers: Content-Disposition');// 加上这句,axios才能获取到header中的content-disposition
header('Content-Disposition:attachment;filename='.$name);
header('Cache-Control:max-age=0');
$objWriter =\PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;