CODEWITHSUNDEEP
c#exceloffice-interop
proton
proton

Reputation: 431

reducing Excel access time

I'm am working in c# with Excel files, using Microsoft.Office.Interop.Excel. My problem is that my program runs very slow. Basically, what it does is to iterate through the cells of an Excel sheet, and read the data in each one of the cells.

I use the following command:

value = (range.Cells[row, col] as Excel.Range).Value2;

where value is my variable, and range is an Interop.Excel object of the Range class.

Is there a beter way in Interop to access an access file , or another library which I should use?

Upvotes: 3

Views: 177

Answers (2)

Juergen
Juergen

Reputation: 151

Excel Data Reader

Lightweight and very fast if reading is your only use case.

Upvotes: 0

Christian Sauer
Christian Sauer

Reputation: 10969

If at any possible, use a library like EPPLUS, which is MUCH more faster than interop and a lot easier to program.

If not possible due to external constraints, try to reduce the number of interop calls as much as possible. Doing the looping in excel is asking for trouble - since each cell has to acessed via interop and the marshalling of data from excel to your app eats a lot of time. It is much better to use get_Range() to get the whole array in one go. The single request will take a long time, but looping in C# is extremely fast afterwards. In general, it is beneficial to do anything you can on the C# side - even if excel would offer the same functionality.

Upvotes: 1

Related Questions