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