Google drive downloaded .xlsx format sheets not working

[tabish-zilingo]

I used google sheet for adding entries in excel sheet, then i downloaded it in (.xlsx) format, then used this getLastRowNum from this library, its returning zero value. And in case i download it from drive, then open it once in Microsoft excel, simply press ctrl + s, without editing anything, in that case, getLastRowNum is working fine (returning actual number of rows).

Its Urgent - please tell me what to do.

[Matttaylor8910]

We are also seeing this with our application, any update on this?

[pjfanning]

The getLastRowNum is dependent on the dimension data that appears in the sheet xml. This is not always filled in. Iterating over the sheet rows and getting the row num of the last row is an alternative way to get this value.

[Matttaylor8910]

Thank you, using the iterator worked for me!