Hi team.

I have a situation when I'm trying to export to excel with charts. When I use my data and create a piechart in the browser, it looks like this (and it's correct):

But when I try to use the same data to export a piechart in excel, it looks like this (incorrect):

The piechart only uses the first two rows, not the rest.

What could be the problem? Thanks a lot.

Of course. This is the browser code:

<?php

use \koolreport\widgets\koolphp\Table;
use \koolreport\widgets\google\BarChart;
use \koolreport\widgets\google\PieChart;
use \koolreport\widgets\google\ColumnChart;

?> <?php

PieChart::create(array(
    "title"=>"Clasificación de la información",
    "dataSource"=>$this->dataStore('clasificacion_informacion'),
    "columns"=>array(
        "atencion"=>array(
            "label"=>"Tipo de Atención para Información"
        ),
        "cantidad"=>array(
            "type"=>"number",
            "label"=>"Cantidad"
        )
    )
));

?>

And this is the excel code:

<?php

use \koolreport\excel\Table;
use \koolreport\excel\BarChart;
use \koolreport\excel\PieChart;
use \koolreport\excel\LineChart;

$sheet1 = "Clasificacion Informacion";

?> <div sheet-name="ClasifInfo">

<div>
    <?php
        Table::create(array(
            "name"=>'clasificacionInformacion',
            "dataSource"=>'clasificacion_informacion'
        ));
    ?>
</div>
<div range="E1:N13">
    <?php
        PieChart::create(array(
            //'excelDataSource'=>'clasificacionInformacion'
            'title'=>"Clasificaci贸n de la informaci贸n",
            'dataSource'=>'clasificacion_informacion',
            /*"columns"=>array(
                "atencion"=>array(
                    "label"=>"Tipo de Atenci贸n para Informaci贸n"
                ),
                "cantidad"=>array(
                    "type"=>"number",
                    "label"=>"Cantidad"
                )
            )*/
        ));
    ?>
</div>

</div>

Thanks a lot.

Hi.

Yes, I found the sheet and the table. Here's the screenshot:

Thanks.

Good morning.

Thanks a lot, that solved my problem.

Now there is another question, but I don't know if I should use this post or a new one. Is there a way for the piechart to look exactly like the one in the browser? At least with the annotations and numbers. Thanks in advance.