Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi,
I have integrated koolreport to codeigniter. Now I am trying to export a report to Excel using the code
$report = new SponsorReportData();
$report->run()->exportToExcel()->toBrowser("myreport.xlsx");
But instead of generating the report, it downloads the html file as .xlsx file. Can anybody help me to resolve the issue?
I made the following change in the library file \packages\ExcelExportable.php
$objWriter = \PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
$objWriter->save('excelreports/DBExport.xlsx');
Now in the excelreports directory of the server the correct Excel file is saved. But when I try to get it in browser as it was earlier, it contains both html content as well as excel content.Is this because of some header issue? I hope this will help in troubleshooting the issue.
Hi George,
I think it's because you submit the export button to the same report page so it will output the same report header and html first. Later the report could not send an exported excel file to your browser because it already sent header with html data.
Please try to export in the following way, create a php file called myReportExcelExport.php with your export code:
$report = new SponsorReportData(); $report->run()->exportToExcel()->toBrowser("myreport.xlsx");
Then in your report page, use the following export button:
<button type="submit" class="btn btn-primary exportBtn" formaction="myReportExcelExport.php">Export to Excel</button>
Please try this and let us know if there's any problem. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo