Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
This is the class I have defined
class ExcelReport extends \koolreport\KoolReport
{
use \koolreport\export\Exportable;
use \koolreport\excel\ExcelExportable;
}
and here's how I can export to excel
$report = new ExcelReport;
$report->run();
$report->exportToExcel()->toBrowser("MyReport.xlsx");
My question is, I have data stored in PHP array, how how can I export that data in excel.
Please refer to the screenshot below:--
Thank You...
Hi there,
Please use the ArrayDataSource with your array data in your report's setting, then in setup method pipe the datasource to a datastore. Finally in export the datastore to excel:
$report->exportToExcel(array(
'dataStores' => array(
'myDataStore1'
),
))
->toBrowser("myReport.xlsx");
Let us know if you need anything else. Thanks!
This is my class now
class ExcelReport extends \koolreport\KoolReport
{
public function settings()
{
return array(
"dataSources"=>array(
"mydata"=>array(
"class"=>"\koolreport\datasources\ArrayDataSource",
"data"=>$this->params["data"],
"dataFormat"=>"associate"
)
)
);
}
public function setup()
{
$this->src('mydata')
->pipe($this->dataStore("mydata"))
}
}
and for export
$myData = array(
array("name"=>"Peter","age"=>30),
array("name"=>"Mary","age"=>25),
);
$this->loadKoolReport();
$report = new ExcelReport;
$report->exportToExcel(array(
'dataStores' => array(
'myData'
),
))
->toBrowser("myReport.xlsx");
still now its not even generating blank excel
Hi,
Please try this code:
$myData = array(
array("name"=>"Peter","age"=>30),
array("name"=>"Mary","age"=>25),
);
$this->loadKoolReport();
$report = new ExcelReport(array(
"data" => $myData
));
$report->run();
$report->exportToExcel(array(
'dataStores' => array(
'mydata'
),
))
->toBrowser("myReport.xlsx");
If it doesn't work, contact us via email to support@koolphp.net. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo