Hi Eugene,

We are going to release a new version of the Excel package which supports Excel export template. With this new feature you could add and customize report data to the exported excel file like what you describe.

We will notify you via this topic when the new version is released. Thanks!

Hi Eugene,

Please send us an email to support@koolphp.net with title "development Excel package". We are very happy to send you a development version of the Excel package. There could be some minor differences in the final API but most should be consistent enough. Thanks!

Hi Eugene,

In the excel template file (e.g, MyReport.excel.file) you have access to the current report via $this and its parameters via $this->params. So says you want to add your date range parameters to the excel file, one way is to add the followng code:

    <div range="A2:D2" >
        <?php echo "From: " . $this->params["fromDate"] . " to: " . $this->params["toDate"]; ?>
    </div>

To update parameters with the current view when export, you export button should submit your form via post/get method. For example:

<button type="submit" formaction="exportToExcel.php">Export to Excel</button>

Please let us know if we understand your question correctly. Thanks!

If it is the case you add id to your form <form id="my-form" ... then on the Export button (which you can put anywhere), you do:

<button onclick="$('#my-form').submit()">Export</button>

You could set your form's when exporting as well:

var myForm = document.querySelector("#my-form");
myForm.action = "exportExcel.php";
myForm.submit();