Export with extra row with totals

[SuryaWebfox]

PHP: 8.1
Laravel: 9.16
Laravel-Excel: 3.1

I am using a FromQuery export. I would like an extra row at the end of the export that sums up the values of some of the numeric columns. I could not find any examples or anything similar in the documentation.

Thanks for any pointers in the right direction.

[wbetalleluzd]

How resolved?

[mydnic]

Any solution to achieve this ?

[TheArKaID]

For those who still wondering this, we could implements WithEvents, use RegistersEventListeners, add the afterSheet(AfterSheet $event) method, and use something like this inside afterSheet

$event->sheet->setCellValue('A'. $event->sheet->getHighestRow()+1, 'Total: ');

You might wanna merge some cell, or getHighestColumn, etc.