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 :(

[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.