KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Pivot Table Excel Download - Total field changed to {{all}} #314

Open V Vijaykumarr opened this topic on on Jun 11, 2018 - 4 comments

V Vijaykumarr commented on Jun 11, 2018

Hello,

I tried to download the Pivot table using the below code from VIEW.

$IndividualPerformance->run()->exportToExcel(array(
"dataStores"=>array(
	'performance'=>array(
        "rowDimension"=>"row",
        "columnDimension"=>"column",
        "measures"=>array(
          "prod_tot - sum",
          'prod_tot - count',
        ),
        'rowSort' => array(
          'prod_tot - count' => 'desc',
        ),
        'columnSort' => array(
          'created_month' => function($a, $b) {
            return (int)$a < (int)$b;
          },
        ),
        'rowCollapseLevels' => array(2),
        'columnCollapseLevels' => array(1),
        'width' => '100%',
        'headerMap' => array(
          'prod_tot - sum' => 'Team',
          'prod_tot - count' => 'Salesperson | Rookie Join Date',
          '1' => 'January',
          '2' => 'February',
          '3' => 'March',
          '4' => 'April',
          '5' => 'May',
          '6' => 'June',
          '7' => 'July',
          '8' => 'August',
          '9' => 'September',
          '10' => 'October',
          '11' => 'November',
          '12' => 'December',
        ),
  )
)
))->toBrowser('sample.xls');

After download the report has {{all}} instead of total.

Thanks for help.

David Winterburn commented on Jun 11, 2018

Hi,

We've sent an email with a the latest source code file to your email. Please try it and let us know if it fixes your issue. Thanks!

V Vijaykumarr commented on Jun 21, 2018

Fatal error: Class 'PhpOffice\PhpSpreadsheet\Cell\Coordinate' not found in C:\xampp\htdocs\koolreport\koolreport\packages\pivot\PivotExcelExport.php on line 84

This is the Error i get after i update the file which you have sent.

David Winterburn commented on Jun 22, 2018

Hi,

I've just sent to your email the latest version of the Excel package. Please update your Excel folder with it and try if it fixes your problem. Thanks!

V Vijaykumarr commented on Jun 25, 2018

OK thanks, {{all}} issue fixed.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed
solved

Excel