Popular phpExcel library does not work under new WordPress 5.7 and higher, because WP5.7 requires PHP 7.4
As a result, exporting data to an Excel file does not work.
You can switch to new, alternative, modern tools for exporting to Excel tables, or continue to use the familiar phpExcel library, but specially modified for the requirements of PHP 7.4
This modification (2024.05.10 PHP 7.4.3) was done independently, taking into account the flow of falling out errors. It is likely that over time, new problem areas will be identified, but at the moment they are not. All the features you need (for me anyway) work great.
There are no evil facking-hack inclusions. Guaranteed.
List of changes:
\PHPExcel\Shared\OLE.php
\PHPExcel\Writer\Excel5\Worksheet.php
\PHPExcel\Writer\Excel5\Workbook.php
\PHPExcel\Writer\Excel5\Parser.php
\PHPExcel\Cell\DefaultValueBinder.php
\PHPExcel\Cell.php
\PHPExcel\ReferenceHelper.php
\PHPExcel\Worksheet\AutoFilter.php
\PHPExcel\Calculation.php
\PHPExcel\Shared\String.php
\PHPExcel\Calculation\Functions.php
Deleted:
\PHPExcel\Shared\PCLZip
* This library is already included in the set of WordPress libraries .
Free to download.