Excel Import - Looping through spreadsheet by Range

Oct 1, 2013 at 3:31 PM
I would like to circumvent the 1000 row OData Limitation in LightSwitch by looping through a spreadsheet 900 rows at a time using the Range import method:

Excel.Import(this.book, this.Application.ExcelImportWorkbook, "Sheet1", "A1:C4")

However, I don't see how I can determine the size last range, and how I can see when there is no more data in the spreadsheet.