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.
No, this is currently not possible with the Excel library. It sounds like you would need some sort of streaming reader, analogous to the XmlReader (whereas our current Workbook object is analogous to the XmlDocument). You can submit a feature request for something like this.
Has a feature request already been submitted ?
Hello,
I am just checking about the progress of this issue. Is there anything else which I could do for you regarding this matter ?
Thank you for using Infragistics Components.
Hello
After some research, this issue has been determined to be a new feature request. I have sent your feature request directly to our product management team. Our product team chooses new feature requests for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this feature request is FR14026.
If you would like to follow up on your feature request at a later point, you may contact Developer Support management via email. Please include the reference number of your feature request in the subject and body of your email message. You can reach Developer Support management through the following email address: dsmanager@infragistics.com
Thank you for your request.
I'm not sure, but I would recommend submitting it again anyway. The number of requests for a feature does help determine what is planned for each development cycle.