Remove chart_data sheet from exported excel document #1368

Open Carl Steenkamp opened this topic on on Apr 1, 2020 - 1 comments

Carl Steenkamp commented on Apr 1, 2020

Good day,

When exporting an excel report, the "chart_data" sheet is always visible.

Is there an easy way to remove it?

David Winterburn commented on Apr 1, 2020

Hi Carl,

Please open the file koolreport/excel/ExportHandler.php and replace the following line:

    $spreadsheet->addSheet($chartDataSheet);

with these:

    $spreadsheet->addSheet($chartDataSheet);
    $chartDataSheet->setSheetState(ps\Worksheet\Worksheet::SHEETSTATE_HIDDEN);

We will consider adding this as an option in the next releases of Excel package. Thanks!

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo

Labels

help needed

Related package Excel

KoolReport's Forum