Excel Table Complex Header

<?php
require_once "MyReport.php";

$report = new MyReport;
$report->run()->render();

<?php
require_once "../../../load.koolreport.php";

use \koolreport\processes\Map;
use \koolreport\processes\Limit;
use \koolreport\processes\Filter;
use \koolreport\cube\processes\Cube;
use \koolreport\pivot\processes\Pivot;

class MyReport extends koolreport\KoolReport
{
    use \koolreport\export\Exportable;
    use \koolreport\excel\ExcelExportable;
    use \koolreport\excel\BigSpreadsheetExportable;

    function settings()
    {
        return array(
            "dataSources" => array(
                "dollarsales"=>array(
                    'filePath' => '../../../databases/customer_product_dollarsales2.csv',
                    'fieldSeparator' => ';',
                    'class' => "\koolreport\datasources\CSVDataSource"      
                ), 
            )
        );
    }    function setup()
    {
        $node = $this->src('dollarsales')
        ->pipe(new Limit(array(
            200, 0
        )))
        ->pipe($this->dataStore('orders'));

    }
}

<?php
use \koolreport\widgets\koolphp\Table;
use \koolreport\datagrid\DataTables;
?>
<div class="report-content">
	<div style='text-align: center;margin-bottom:30px;'>
        <h1>Excel Table Complex Header</h1>
        <p class="lead">Exporting table with complex headers</p>
		<form method="post">
			<button type="submit" class="btn btn-primary" formaction="export.php?type=excel">Download Excel</button>
			<button type="submit" class="btn btn-primary" formaction="export.php?type=bigspreadsheet">Download Big Spreadsheet</button>
		</form>
	</div>
	<div class='box-container'>
		<div>
			<?php
			DataTables::create(array(
				"dataSource" => $this->dataStore('orders'),
				"columns"=>array(
					"productName",
					"orderYear" => ["label" => "Date-Year"],
					"orderMonth" => ["label" => "Date-Month"],
					"orderDay" => ["label" => "Date-Day"],
					"dollar_sales"=>array(
						"type"=>"number",
						"decimals" => 2,
					)
				),
				"complexHeaderLabels" => true,
				"options" => [
					"paging" => true,
					"order" => [[4, 'desc']],
					"columnDefs" => [
						[
							"targets" => [4],
							"type" => "num-fmt",
						]
					]
				]
			));
			?>
		</div>
	</div>
</div>

<?php
    $sheet1 = "Sales by Customer";
?>
<meta charset="UTF-8">
<meta name="description" content="Free Web tutorials">
<meta name="keywords" content="Excel,HTML,CSS,XML,JavaScript">
<meta name="creator" content="John Doe">
<meta name="subject" content="subject1">
<meta name="title" content="title1">
<meta name="category" content="category1">

<div sheet-name="<?php echo $sheet1; ?>">
    <div>Orders Table</div>

    <div>
        <?php
        \koolreport\excel\Table::create(array(
            "dataSource" => $this->dataStore('orders'),
            "columns"=>array(
                "productName",
                "orderYear" => ["label" => "Date-Year"],
                "orderMonth" => ["label" => "Date-Month"],
                "orderDay" => ["label" => "Date-Day"],
                "dollar_sales"=>array(
                    "type"=>"number",
                    "decimals" => 2,
                )
            ),
            "complexHeaderLabels" => true,
            "sorting" => [
                "dollar_sales" => "desc",
            ]
        ));
        ?>
    </div>
    
</div>

<?php
include "MyReport.php";
$report = new MyReport;
$report->run();

$exportType = $_GET["type"];
if ($exportType === "excel") {
    $report->exportToExcel('MyReportExcel')->toBrowser("MyReportExcel.xlsx");
} else {
    $report->exportToXLSX('MyReportExcel')->toBrowser("MyReportBigSpreadsheet.xlsx");
}