My excel export runs incredibly slowly. When trying to export a 10,000 line array, it can take upwards of 5 minutes for the file to finish building.

Below is my code.

<?php
use \koolreport\excel\Table;

$sheetName = 'sheet1';
?>
<div sheet-name="<?php echo $sheetName; ?>">
    <div>
        <?php
        Table::create(array(
            "dataSource" => $this->exportData,
        ));
        ?>
    </div>
</div>

public function exportNamedReport(Request $request)
    {
        $report = $request->route()->getAction()['report'];
        $pageTitle = $request->route()->getAction()['pageTitle'];
        $use = "App\Reports\\$report";

        $report = new $use;
        $report->run();
        $report->exportToXLSX('reportExport')->toBrowser($pageTitle.".xlsx");
    }

To reproduce these issues, I have been sending 10,000 line arrays via this code:

while ($i < 10000){
                $export[] = array('test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test');
                $i += 1;
            }
$this->exportData = new \koolreport\core\DataStore($export);

Any ideas would be appreciated.

That is what I am currently using. On my report I have

use \koolreport\excel\BigSpreadsheetExportable;

I am having an issue getting an array into the datastores. Because I want to have more dynamic report creation, I have it setup a bit differently then the examples. Also, as a side note, I am using Laravel.

So I have a controller that runs this code

public function getNamedReport(Request $request)
    {
        $report = $request->route()->getAction()['report'];
        $path = $request->path();
        $pageTitle = $request->route()->getAction()['pageTitle'];
        $use = "App\Reports\\$report";

        $report = new $use;
        $report->run();
        return view("admin.reports.layout", ["report" => $report, "pageTitle" => $pageTitle, "path" => $path]);
    }

and then I have separate reports that generate their own data. Right now I have them generating that data in the setup function which is what I was doing with this:

while ($i < 10000){
                $export[] = array('test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test','test');
                $i += 1;
            }
$this->exportData = new \koolreport\core\DataStore($export);

and then they get displayed like this:

Table::create(array(
    "dataStore"=>$this->data,
    ...
));

Is there a more proper way of generating and passing arrays without having to do this?

$report = new MyReport(array(
    "data"=>array(
        array("Item","Cost"),
        array("Accessories",3000),
        array("Human Resource",20000),
        array("Material",50000),
        array("Machine",30000),
        array("Accessories",5000),
        array("Machine",10000),
        array("Material",20000),
    )
));
$report->run()->render();

Those examples show only static setting of arrays. How would I put an array that gets pulled from a database and manipulated into there?