Export to Excel

vallstn · November 28, 2021, 10:54am

I am facing issue with export to excel. I am using codeigniter 4 GroceryCRUD 2.9.2, However export to pdf and print works as expected. The error details.

ErrorException

Required parameter $pValue follows optional parameter $pCoordinate

APPPATH\Libraries\GroceryCrudEnterprise\scoumbourdis\phpexcel\Classes\PHPExcel\Autoloader.php : 79 — CodeIgniter\Debug\Exceptions->errorHandler

`$severity`	8192
`$message`	Required parameter $pValue follows optional parameter $pCoordinate
`$file`	D:\webdevelopment\08-08-2021_New_Build\30-10-2021\ci4\app\Libraries\GroceryCrudEnterprise\scoumbourdis\phpexcel\Classes\PHPExcel\Worksheet.php
`$line`	1477

APPPATH\Libraries\GroceryCrudEnterprise\grocerycrud\enterprise\src\GroceryCrud\Core\State\ExportState.php : 195 — GroceryCrud\Core\State\ExportState->exportToExcel ( arguments )
$data

Array
(
[0] => Array
(
[userid] => test
[scheme] => Replacement of Old Pumpsets
[office] => CUDDALORE
[insdate] =>
[officer] =>
[workcompleted] =>
[document] =>
[invoice] =>
[paymentcompleted] =>
[central] =>
[state] =>
[farmer] =>
)

)

$columns

Array
(
[0] => stdClass Object
(
[name] => userid
[displayAs] => Farmer Name
)

[1] => stdClass Object
    (
        [name] => scheme
        [displayAs] => Scheme
    )

[2] => stdClass Object
    (
        [name] => office
        [displayAs] => Office
    )

[3] => stdClass Object
    (
        [name] => insdate
        [displayAs] => Inspection Date
    )

[4] => stdClass Object
    (
        [name] => officer
        [displayAs] => Inspection Official
    )

[5] => stdClass Object
    (
        [name] => workcompleted
        [displayAs] => Work Completed (Yes / No)
    )

[6] => stdClass Object
    (
        [name] => document
        [displayAs] => Inspection Document
    )

[7] => stdClass Object
    (
        [name] => invoice
        [displayAs] => Invoice
    )

[8] => stdClass Object
    (
        [name] => paymentcompleted
        [displayAs] => Payment Completed (Yes / No)
    )

[9] => stdClass Object
    (
        [name] => central
        [displayAs] => Central Share Relesed (Rs.)
    )

[10] => stdClass Object
    (
        [name] => state
        [displayAs] => State Share Relesed (Rs.)
    )

[11] => stdClass Object
    (
        [name] => farmer
        [displayAs] => Farmer Share Relesed (Rs.)
    )

)

Kindly help.

johnny · November 28, 2021, 11:26am

Hello @vallstn and welcome to our forums

We’ve tracked this issue that the export to excel doesn’t work for PHP 8. Can you please confirm that the version of PHP is version 8 or later? I will try to fix this issue for the next release.

Regards
Johnny

vallstn · November 28, 2021, 12:37pm

Yes I am using PHP 8.0.11, Thanks for immediate response. I am waiting for next update.

johnny · November 28, 2021, 7:12pm

Hello @vallstn ,

I am glad to inform you that the latest version of Grocery CRUD Enterprise (2.9.3) now includes the fix for the export to excel. In order to download the latest version visit the page: User's Page Login

Let me know if that worked for you.

Regards
Johnny

vallstn · November 29, 2021, 4:11am

Thanks Johnny,

Now it is working.

Regards,
Vallstn

sbaltaz · March 21, 2022, 2:33pm

Hi,

I’ve just downloaded the latest version (grocery-crud-enterprise-with-codeigniter-4-v2.9.3.zip), and still have the same issue of the previous version regarding export to Excel: ERR_INVALID_RESPONSE

Basically,
This works: https://my_site/public/index.php/main/referencias?action=export-pdf&page=1&per_page=10&order_by=referencia&sorting=asc

This doesn’t work: http://my_site/public/index.php/main/referencias?action=export&page=1&per_page=10&order_by=referencia&sorting=asc

Can you please provide me some advice ?

Thank you in advance.
Sérgio

johnny · March 29, 2022, 3:30pm

Hello @sbaltaz and sorry for the delay,

I couldn’t reproduce the issue but after updating PHP to version 8.1 the issue is now reproducible. Can you please confirm that the PHP version that you use is 8.1?

I’ve fixed some issues with PHP 8.1 for 2.9.3 but I am still investigating on this one.

Regards
Johnny

sbaltaz · March 30, 2022, 1:08pm

Hello @johnny,

Thank you for your answer.
I’m using PHP 7.4.3.

In the meanwhile, while you’re working on this issue, can you please tell me in which PHP version both exports are working correctly ?

Thank you.

Best regards
Sérgio

johnny · April 3, 2022, 2:09pm

Hello @sbaltaz ,

I am glad to inform you that I’ve fixed the issue and you can find it available on the latest version (2.9.4). The fixes are as following:

Version 2.9.3 is fixing the issues that we had for PHP 8.0
Version 2.9.4 is fixing the issues that we had for PHP 8.1

Regards
Johnny

sbaltaz · April 5, 2022, 7:39am

Hello @johnny,

Thank you for your time and work.
I’ll give a try to the next version and let you know the results.

Best regards,
Sérgio

sbaltaz · April 19, 2022, 1:37pm

Hello @johnny,

I’d like to inform you that Version 2.9.4 fixes the excel’s exportation problems, in PHP 7.4.3.
Thank you for your time and good work.

Best regards,
Sérgio

GabrielD · August 1, 2022, 4:23pm

Hi @johnny ,

some of my grids are exporting in php 8.1 some of them not. I guess is because the grids that are not exported contains a date field.

here are my findings:
grep -r --include=“*.php” strftime .
./scoumbourdis/phpexcel/Classes/PHPExcel/Calculation/DateTime.php: $testVal3 = strftime(‘%Y’);
./scoumbourdis/phpexcel/Classes/PHPExcel/Calculation/DateTime.php: $PHPDateArray[‘year’] = strftime(‘%Y’);
./scoumbourdis/phpexcel/Classes/PHPExcel/Calculation/DateTime.php: $PHPDateArray[‘month’] = strftime(‘%m’);
./scoumbourdis/phpexcel/Classes/PHPExcel/Calculation/DateTime.php: $PHPDateArray[‘day’] = strftime(‘%d’);

I solved by adding the error_reporting line in ./grocerycrud/enterprise/src/GroceryCrud/Core/State/ExportState.php,
but I don’t know for why just worked …

public function exportToExcel($data, $columns)
{
    error_reporting(E_ERROR | E_WARNING | E_PARSE);

KR,
Gabriel

johnny · August 3, 2022, 5:04am

Hello @GabrielD ,

Yes you are right, this is one more issue with PHP 8.1 (or PHP 7 in your case?) . Specifically if the value is a float number. I’ve fixed that on the PHP Excel repo: Fixing issue with PHP 8.1 deprecated error "Implicit conversion from … · scoumbourdis/PHPExcel@e43a89c · GitHub

Now from your findings we may also have the same issues with dateTime? I will investigate and let you know.

Thanks for the update @GabrielD by the way, it really helped As PHPExcel is deprecated I am trying to do all the updates myself and it is hard to keep track of every new deprecation from PHP 8 (or even in some cases PHP 7)