Update for compatible with PhpSpreadsheet 2.0.0

[TamHoChi3008]

I need to clone a sheet with a chart in phpSpreadsheet, but this feature is only available in phpSpreadsheet 2.0.0, and this is uncompatible with MaatWebsite/Excel's latest version.

Something bonus: why don't we add the $readMode option config reader flag?

public const LOAD_WITH_CHARTS = 1;
public const READ_DATA_ONLY = 2;
public const SKIP_EMPTY_CELLS = 4;
public const IGNORE_EMPTY_CELLS = 4;

public function reopen(TemporaryFile $tempFile, string $writerType, int $readMode = 0)
{
    $reader            = IOFactory::createReader($writerType);
    $this->spreadsheet = $reader->load($tempFile->sync()->getLocalPath(), $readMode);

    return $this;
}
...
$loadWithChart = \PhpOffice\PhpSpreadsheet\Reader\IReader::LOAD_WITH_CHARTS;
$event->writer->reopen($file, Excel::XLSX, $loadWithChart);

I'm new to work with excel in PHP, thanks for any help !!

[patrickbrouwers]

2.0 will be supported in the next release, no ETA sorry

[jesseyvanofferen-4s]

Hey, I was wondering if there's been any change in knowing any ETA? We want to upgrade our php to 8.3, this however won't be possible untill the PhpSpreadsheet 2.0 support has been released.

[patrickbrouwers]

No updates sorry. This package and PhpSpreadsheet run just fine on PHP8.3, see: https://github.com/SpartnerNL/Laravel-Excel/actions/runs/8730377756/job/23954090913

[vaawebdev-ozee]

Hey guys, do you have any updates with PhpSpreadsheet 2.0 support?
Do you have any working branch for that or something? Will be gald to help with the upgrade.

[patrickbrouwers]

No updates sorry, currently no time to finish it up unfortunately :(

[jovel-luna]

as of this writing, phpoffice/phpspreadsheet is now on v4, yet this package still only supports v1, meaning that this package is way behind any potential security patches and improvements that phpspreadsheet may already implemented (Unless #4302 is finally merged). So at the very least, would appreciate any information as to when the support for these versions are coming?

[taoyipai]

Hey guys, do you have any updates with PhpSpreadsheet 2.0 support? We need to add cell borders in ODS which was included in release 2.0.0.

[didzis85]

Hi guys!
Any update on the ETA of 2.0 support?

[holmesadam]

Ideally I would like support for v4 - but when is support for v2 coming?

[1YalcinSahin1]

As stated at the following link https://github.com/PHPOffice/PhpSpreadsheet/releases, can you upgrade the phpoffice/phpspreadsheet package to the latest version?

@patrickbrouwers