Hi, I'm currently trying to apply some style on a pivot table excel export, it exports well but without style.

Im I doing it wrong ? Does pivot supports custom style ? I would like to change columns color and have bold headers. I actually spent the whole day on it. I have koolreport pro.

Here's my PivotTable's array datasource :

and my template TablePivot.excel.php

<div sheet-name="<?php echo "Non-conformités"; ?>">
	<div cell="A1" range="A1:H1">
        <?php echo "Export non conformite"; ?>
    </div>
	<div>
        <?php
PivotTable::create(array(
            "dataSource" => 'values',
            "columnsExcelStyle" => [
                'transporteur' => [
                    'font' => [
                        'italic' => true,
                        'size' => 30,
                        'color' => [
                            'rgb' => '818580'
                        ]
                    ],
                    'fill' => [
                        'fillType' => 'darkGray'
                    ]
                ],
                'indicateur' => [
                    'font' => [
                        'italic' => true,
                        'size' => 30,
                        'color' => [
                            'rgb' => '801280'
                        ]
                    ],
                    'fill' => [
                        'fillType' => 'darkGray'
                    ]
                ]
            ]
            // enleve l'header des lignes
            'headerMap' => array(
                $this->settings['countvalue'] . ' - count' => ''
            )
        ));
        ?>
    </div>
</div>

Thank you in advance for your interest and have a nice day

Any update on adding styles to the pivot table? We frequently use the pivot table to show data but manually changing the format is time consuming if we do it and frowned upon if we require the end users to perform this task.

Thanks