Export as Excel - KoolReport

V

V Vijaykumarr commented on Jul 4, 2018

Hello,

I am using this php report example as a reference.

What is the export code for the above report.

Please guide to export the loaded result as excel.

I am using the below code

require_once "OrderList.php";
$report = new OrderList;
$report->run()->exportToExcel()->toBrowser("Property Listings.xls");

But exported report shows,

<b>Warning</b>:  array_keys() expects parameter 1 to be array, null given in <b>C:\xampp\htdocs\reports\koolreport\packages\excel\ExcelExportable.php</b> on line <b>37</b><br />

Thanks.

K

KoolReport commented on Jul 5, 2018

May be you should follow this pdf export example and replace the PDF export to Excel export.

D

David Winterburn commented on Jul 6, 2018

Hi Vijay,

It seems there's some datastore in your report that has no data which caused the null error when we called array_keys function. Please specify the exact datastore you want to export like this:

->exportToExcel(array('myDatastore'))
->toBrowser("Property Listings.xls");

Please try this and let us know if there's still problem. Thanks!

KoolReport's Forum

Export as Excel #348

Build Your Excellent Data Report