Some issue With PHP SpreadhSheet and Chart Sheet

Software version used

  • PHP 7.3.12
  • Symfony 4.4
  • PHP Spreadsheet 1.14 -> 1.15 (updated but no changes)

Hi erverybody !
I have some issues with using PHP SpreadSheet
I have an excel template with two sheet. One with somme data and the other one with a graph
I just want to open the Excel document, fill the data and then downloading it with chart updated

When I use Xls extension, even if I just read, load and write the excel file without add nothing, the chart worksheet disapears.
Even with some options added it doesn’t work

$objReader->setIncludeCharts(true);
$objReader->setLoadAllSheets();
$writer->setIncludeCharts(true);
$writer->setPreCalculateFormulas(true); 
ob_end_clean();

If i use Xlsx extension, a fatal error occurs with this message

Undefined index: rId2 (500 Internal Server Error) 

With somme google research i noticed a lot of github issues and/or forum post but never found a solution
Maybe you can help me with this issue ?

Source: Symfony Questions

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *