如何解决“允许内存大小耗尽”错误？

Question

我正在使用phpspreadsheet，我想修改一个有4张表的xlsx文件。我只想在2张表中插入数据，但我想将所有4张表复制到新的xlsx文件中。当我这样做时，我会得到以下错误：

ini_set('memory_limit', -1);

$inputFileType = 'Xls';
$inputFileName = './sampleData/example1.xls';
$sheetnames = ['Data Sheet #1','Data Sheet #3'];

/**  Create a new Reader of the type defined in $inputFileType  **/
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
/**  Advise the Reader of which WorkSheets we want to load  **/
$reader->setLoadSheetsOnly($sheetnames);
/**  Load $inputFileName to a Spreadsheet Object  **/
$spreadsheet = $reader->load($inputFileName);

编辑：我已经尝试用下面的代码复制我不需要编辑的工作表：

$spreadsheet1 =\PhpOffice\PhpSpreadsheet\IOFactory::load("./sampleData/example1.xls");
$clonedWorksheet = clone $spreadsheet1->getSheetByName('Data Sheet #2 ');
$clonedWorksheet->setTitle('Test');
$spreadsheet->addSheet($clonedWorksheet);

但现在我得到另一个错误：

致命错误：未捕获错误：调用C:\xampp\htdocs\offerconfigurator\vendor\phpoffice\phpspreadsheet\src\phpspreadsheet\calculation.php:2785堆栈跟踪:#0C:\xampp\htdocs\offerconfigurator\vendor\phpoffice\phpspreadsheet\src\phpspreadsheet\cell\cell.php(262):phpoffice\phpspreadsheet\cell\calculateCellvalue（对象pspreadsheet\src\phpspreadsheet\writer\xlsx\worksheet.php(1077):phpoffice\phpspreadsheet\cell\cell\getcalculatedvalue()#2c:\xampp\htdocs\offerconfigurator\vendor\phpoffice\phpspreadsheet\src\phpspreadsheet\writer\xlsx\worksheet.php(1027):phpoffice\phpspreadsheet\writer\xlsx\worksheet.php(ampp\htdocs\offerconfigurator\vendor\phpoffice\phpspreadsheet\src\phpspreadsheet\writer\xlsx\worksheet.php(76):PhpOffice在C:\xampp\htdocs\offerconfigurator\vendor\PhpOffice\phpspreadsheet\src\phpspreadsheet\calculation\calculation.php在第2785行

我认为这是因为克隆不能复制公式。这会是原因吗？用公式复制一张表是另一种解决方案吗？

Answer 1

我终于找到了解决办法。问题出在编写器和公式上，所以将这一行添加到代码中，现在它工作得很好：

$writer->setPreCalculateFormulas(false);

所以现在编写器的所有代码是：

$writer = new Xlsx($spreadsheet);
$writer->setPreCalculateFormulas(false);
$writer->save('test.xlsx');