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

Posted by Santosh4u under VB.NET on 10/10/2016 | Points: 10 | Views : 2159 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,
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.

Thanks
Santosh

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	Dear Sontosh Sir, We have written an article on the same using LinqToExcel ( http://www.dotnetfunda.com/articles/show/3229/reading-excel-and-csv-file-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] Bronze | Points: 25

0	Hi, 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 Mani.R Santosh4u, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,

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

Mani.R

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

Latest Posts