以下为部分源码
header('Content-Type: application/vnd.openxm
header("Content-Disposition: attachment;filename=\"$fileName\"");
header('Cache-Control: max-age=0');
$objWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($spreadsheet, 'Xlsx');
$objWriter = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
// $objWriter->save('php://output');
$objWriter->save('/download/tmp/'.$filenNme);//测试
// $this->saveExcelToLocalFile($objWriter,fileName);die;
$response = array(
'success' => true,
'url' => $this->saveExcelToLocalFile($objWriter,$fileName)
);
echo json_encode($response);
exit();
}
public function saveExcelToLocalFile($objWriter,$filename){
// make sure you have permission to write to directory
$filenameGBK=iconv("UTF-8", "GBK", $filename);
$filePath = './download/tmp/'.$filenameGBK.'.xlsx';
$objWriter->save($filePath);
return str_replace('./','/','./download/tmp/'.$filename.'.xlsx');
}
最佳答案
