Export to Excel

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

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

Hello @vallstn and welcome to our forums :hugs:

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

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

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

Thanks Johnny,

Now it is working.

Regards,
Vallstn

1 Like

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

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

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

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:

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

Regards
Johnny

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

Hello @johnny,

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

Best regards,
Sérgio

1 Like