B4J Question Is there a way to detect EOF in an xlsx file in B4J

JackSparrow said:

Other than reading it from beginning to end that is

Thanks for any replies

Click to expand...

walt61 said:

Wild guess: if it's the 'last row of a worksheet' you mean, see https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/ :

B4X:

Dim result As XLReaderResult = XL.Reader.ReadRange(File.DirAssets, "Countries of the world.xlsx", "Sheet1!B3:E1000")
Log(result.BottomRight.Row0Based + 1)

Click to expand...