bseddon / php-pivottables-4-excel-lite Goto Github PK

I would love to use the extension. I am currently using PHP 8. Unfortunately the project is limited to PHP 7.x. Is it possible to change this? Or are there compatibility issues?

Hi I am using PHP version 7.4.27 and i have tried to-get it working phpspreadsheet to
phpoffice/phpspreadsheet": "^1.22",

When i use the your settings version 7.0 and 1.5 with this command
composer require lyquidity/php-pivottables-4-excel-lite:dev-master --prefer-dist

Fatal error: Declaration of lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($pFilename): void must be compatible with PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($filename, int $flags = 0): void in C:\xampp\htdocs\Pivot\vendor\lyquidity\php-pivottables-4-excel-lite\phpspreadsheet\XlsxWriter.php on line 201

Then i tried to use,
1. composer update --verbose (with the setting 7.4 and 1.22)
2. composer require lyquidity/php-pivottables-4-excel-lite:dev-master --prefer-dist
I still get the same error.

Fatal error: Declaration of lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($pFilename): void must be compatible with PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($filename, int $flags = 0): void in C:\xampp\htdocs\Pivot\vendor\lyquidity\php-pivottables-4-excel-lite\phpspreadsheet\XlsxWriter.php on line 201

What am i doing wrong

I always get the following error, after opening the created Excelfile with a pivot table in it:

The following repairs were done:x000d__x000a__x000d__x000a">Repaired records: PivotTable report from /xl/pivotCache/pivotCacheDefinition619f679649ca5.xml-part (PivotTable Cache).

Any idea? Whats wrong?

Using the latest dev-master of this library. I get the following error when overriding the Xlsx reader library:

Attempted to call an undefined method named "securityScan" of class "lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Reader\Xlsx".

PhpSpreadsheet version 1.15.0 does not have this method anymore. They are using $this->securityScanner->scan() now.

I'm trying to run the library with Laravel 5.7 with Php7.

And always getting the same error with almost all of the new classes:

each method its deprecated.

I change each while(list) each I found
for
foreach($somegroup as $key=>$var)

and now I'm getting empty arrays.

Could you help me, please?

Hello again. I am very grateful that you allow us to create a pivot table with your tools.

However, I would need "real" filters for a customer as you see in the screenshot below. Unfortunately, I have not been able to get it to work.

Illuminate\Foundation\ComposerScripts::postAutoloadDump
PHP Fatal error: Declaration of lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Writer\Xlsx\Rels::writeWorksheetRelationships(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pWorksheet, $pWorksheetId = 1, $includeCharts = false) must be compatible with PhpOffice\PhpSpreadsheet\Writer\Xlsx\Rels::writeWorksheetRelationships(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $worksheet, $worksheetId = 1, $includeCharts = false, $tableRef = 1) in C:\xampp\htdocs\xxx\vendor\lyquidity\php-pivottables-4-excel-lite\phpspreadsheet\Xlsx\Rels.php on line 204

Fatal error: Declaration of lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Writer\Xlsx\Rels::writeWorksheetRelationships(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pWorksheet, $pWorksheetId = 1, $includeCharts = false) must be compatible with PhpOffice\PhpSpreadsheet\Writer\Xlsx\Rels::writeWorksheetRelationships(PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $worksheet, $worksheetId = 1, $includeCharts = false, $tableRef = 1) in C:\xampp\htdocs\xxx\vendor\lyquidity\php-pivottables-4-excel-lite\phpspreadsheet\Xlsx\Rels.php on line 204

Installation failure.