search

monitorjbl / excel-streaming-reader

An easy-to-use implementation of a streaming Excel reader using Apache POI
Apache License 2.0
960 stars 345 forks source link

Google drive downloaded .xlsx format sheets not working #211

Open tabish-zilingo opened 4 years ago

tabish-zilingo commented 4 years ago

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 commented 2 years ago

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

pjfanning commented 2 years ago

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 commented 2 years ago

Thank you, using the iterator worked for me!