Geeks, please accept the hero post of 2021 Microsoft x Intel hacking contest>>>
There are a lot of ways on the Internet
1. The error of header and buffer result in calling save(“ php://output “Before calling ob_ end_ clean()
2. Delete the break in line 581 of the file
3. Will: $objwriter = – phpexcel_ IOFactory::createWriter($objPHPExcel, ‘Excel5’); Modify to $objwriter = phpexcel_ Writer_ Excel2007($objPHPExcel);
4. Change the export file suffix to. Xlsx
The final solution: change the above method 3excel5 to Excel2007: $objwriter = – phpexcel_ IOFactory::createWriter($objPHPExcel, ‘Excel2007’);
Similar Posts:
- [Solved] Java.nio.file.AccessDeniedException is reported when moving excel files in Tomcat project
- Python ImportError: No module named win32com.client [How to Solve]
- Python uses xlwt length limit to report errors
- Python: How to Batch Read the Form Information in Word and output them to Excel file
- [Solved] Changing the selected file Error when uploading excel file. Net:: err_UPLOAD_FILE_CHANGED
- jxl.read.biff.BiffException: Unable to recognize OLE stream
- [Solved] Java read excel file unable to recognize ole stream error
- Ax2009 export excel 2016+ version error [How to Solve]
- Error reporting when installing r reference rjava on MAC
- Python Pandas: Read_Excel() and to_Excel() function