how to make performance faster while reading excel files [Resolved]

Posted by Santosh4u under VB.NET on 10/10/2016 | Points: 10 | Views : 117 | Status : [Member] | Replies : 2
i am trying to read excel cell values from excel sheets and i am doing this by opening the excel files and reading values using by two loops by rows and columns.

but i am facing problem is that it's taking long time to process all the excel files.
is there any best way to read excel files and bind to dataset.

i have different kinds of files in different folders(each folder contains 100 excel files) and for each sheet i have defined sheetname,rowstart ,rowend, headerstart, headerend to use in loop for rows and columns and i have loaded this into datatable.
while processing the excel files , i have filtered the above datatable based sheetname and then start looping based on row start, row end and columnstart and columnend.

is there any tool where i can pass rowstart , rowend, columnstart,columnend to read excel cell values.

Please help me on this.



Posted by: Rajnilari2015 on: 10/10/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50


Dear Sontosh Sir,
We have written an article on the same using LinqToExcel ( )

Please try that one.

Hope that helps.

Thanks & Regards,
RNA Team

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Manicse on: 10/11/2016 [Member] Starter | Points: 25


To read from excel and upload in our application might cause performance degradation.
Similar experience when I faced I got two solutions.
1. Open XML - Converting the entire spreadsheet into XML format and reading information from the XML.
2. Using Aspose.Cells - This is 3rd party tool which is much useful for excel type of works in .net


Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response