GetRows loops on empty cells but with a style

[Bagu3tte]

Hello, I would like to know if there is an alternative function to GetRows that will only return cells with content?

Example:

If I do a len(GetRows("sheet1")) on the sheet in example, the len function will return 1048576 instead of 2.

[xuri]

Thanks for your issue. Could you tell me which version of Excel that created this file? and please provides file attachments if you can. This lib will check the last XML element of worksheet inner the xlsx file when you call the function GetRows(), then
autofill the entire cell of the worksheet with the empty value.

[Bagu3tte]

I used Google Sheets and exported to .xlsx.
example.xlsx