| || |
How to imporve Excel Read performance
My scenario goes like this, I have a set of excel sheet with filled data in various rows and cols I need to traverse all sheets randomly and fetch the row and col data and perform the operation in the application, I felt performance bottleneck resides switching between sheets and read the data. Is there any way to improve this performance?
I thought of implement Excel - ADODB concept for this. Will it be really valuable? It would be appreciable if any one throws some valuable thoughts to this query,