PhpSpreadsheet损坏文件 [英] PhpSpreadsheet is corrupting files

问题描述

我正在使用PhpSpreadsheet修改现有文件并将其发送到浏览器，但是每次下载文件时，excel都会给我以下错误:

I am using PhpSpreadsheet to modify an existing file and send it to the browser, but every time I download the file excel gives me the following error:

我们发现filename.xlsx中的某些内容存在问题.您是否希望我们尽力而为?如果您信任此工作簿的来源，请单击是".

We found a problem with some content in filename.xlsx. Do you want us to try and recover as much as we can? If you trust the source of this workbook, click Yes.

我已将所有内容剥离回以下代码.我要打开的模板文件是一个全新的excel文件，未对其进行任何编辑(以避免该模板中已经存在该错误的可能性).我可以从驱动器中打开此文件，而不会出现任何问题.

I have stripped back everything to the following code. The template file that I am opening is a brand new excel file, with no edits made to it (to avoid the potential that the error already exists in the template). I can open this file from the drive without any issues.

$spreadsheet = IOFactory::load(storage_path() ."\Template - English.xlsx");

// Redirect output to a client’s web browser (Xlsx)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="filename.xlsx"');
header('Cache-Control: max-age=0');

// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0

$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');

完成修复过程后，我从Excel中收到以下消息，并且一切正常.

Once I go through the repair process I get the following message from Excel, and everything seems to work fine.

Excel已完成文件级别的验证和修复.该工作簿的某些部分可能已被修复或丢弃.

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.

**** 当我使用$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

** ** The same error occurs when I generate a new file using $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

推荐答案

我不知道您是否解决了您的问题，但我有同样的想法. 我的代码如下:

I don't know if you solved your issue but I had the same. My code looks like this :

$strFilename = sprintf('%s_%s_subscriptions', date('Y-m-d-H-i'), $alias);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="'.$strFilename.'.xlsx"');
header('Cache-Control: max-age=0');
$writer = IOFactory::createWriter($objSpreadsheet, 'Xlsx');
$writer->save('php://output');

Excel会提示与您相同的错误.但是看起来PHPSpreadSheet创建了一个缓冲区，并且在保存电子表格后不会将其关闭. 通过添加模具"；在最后一行之后，它解决了问题...

And Excel prompt the same error as you. But it looks like PHPSpreadSheet create a buffer and doesn't close it once you save the spreadsheet. By adding a "die;" after the final line, it solved the issue...

最后的代码:

$strFilename = sprintf('%s_%s_subscriptions', date('Y-m-d-H-i'), $alias);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="'.$strFilename.'.xlsx"');
header('Cache-Control: max-age=0');
$writer = IOFactory::createWriter($objSpreadsheet, 'Xlsx');
$writer->save('php://output');
die;

希望有帮助！

这篇关于PhpSpreadsheet损坏文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！