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

[JackSparrow]

Other than reading it from beginning to end that is

Thanks for any replies

 

[Erel]

I don't understand. Are you using XLUtils to read the file?

 

[walt61]

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/ :

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

 

[JackSparrow]

Other than reading it from beginning to end that is

Thanks for any replies

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/ :

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

Thank you Walt, Yes I read those pages over and over, I must have become glazed.
Thanks for the solution