Laravel-excel: [QUESTION] Is there any method to get highest row and column on dynamic data using FrowView (blade) ?

[bossyahrul]

Prerequisites

• [X] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [X] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [X] Checked that your question isn't already asked before.
• [x] Filled in the entire issue template

Versions

• PHP version: 7.2.5
• Laravel version: 7.0
• Package version: 3.1

Description

I have a Export class using FrowView (blade table). And I want to put an 'all borders' to every rows and columns so that all the exported data have a border and forming a table. My data have a dynamic number of rows and columns.

Does Laravel-Excel have a method to get the highest row and column (ex: "A2:AG12") so that I don't need to create a logic to get the excel's column name and do a join query on my repository to get the row num?
Any help would be very appreciated! Thanks.

Additional Information

Only single sheet need to be exported.

[bossyahrul]

Update: i've found a way to get string from index manually using query to determine the index value in integer:
\PhpOffice\PhpSpreadsheet\Cell\Coordinate::stringFromColumnIndex($index);

[patrickbrouwers]

In AfterSheet event:

$sheet->getDelegate()->getHighestRow()
$sheet->getDelegate()-> getHighestColumn();

[bossyahrul]

You're my hero! Thanks a lot!