Hi all, I'm fairly new to Infragistics.Excel, so maybe I'm missing something.

I am wanting to load in the first 25 rows of an Excel spreadsheet in order to gain a hueristic understanding of the rest of the data, and display something meaningful to the user before continuing with the real work. I have some pretty aggressive excel file size targets I'm trying to meet for this application, and I am currently testing with a spread sheet that has a modest 50,000 rows and 40 columns. From what I can gather, it is necessary to call Workbook.Load before I can do anything, but of course this reads and parses the entire file which takes in the order of minutes.

My question is, is there a way using the Infragistics.Excel classes to quickly read in the worksheet collection, and then the first 25 rows of a given worksheet without loading the entire excel file into memory?

Thanks.