Hello Support,
We are using Inragistics.Excel library to read the data from excel. Our requirement is that the user will select the workbook and we have display all the worksheets name in a drop down. Then only the selected worksheets data is to be read and displayed in the grid. We observed that every for getting the worksheets name we have use the .Load method, which I assume reads the entire data from the excel. We observed that if any of the sheet has large data then it takes quite a bit of time to do so. So is there any way to get the worksheet names directly instead of Loading the entire workbook.
There have been some performance fixes recently in versions 11.1 and 11.2. So if you have not done so, you should upgrade to the latest SR and version if possible and see if you are experiencing the same slowness.
Currently there is no way to get the worksheet names without loading the entire file. I have forwarded this post to the Developer Support Manager and a DS engineer will be submitting a feature request on your behalf.
Hello,
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 FR14134.
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.
Sincerely,ValerieDeveloper Support EngineerInfragistics,Incwww.infragistics.com/support