Reading an Excel Sheet containing 10000 Rows In C#

Question

Possible Duplicate:
Reading Excel Files as a Server Process

While the Jet OleDB Driver is pretty simple to use for reading an Excel sheet, it simply cant handle excel files having rows more than a thousand.

Is there any other way of reading more than 5-10k rows from an excel sheet in C#?

I used the Jet OleDB Driver in the past and read many more than a thousand rows.... — Mitch Wheat, Mar 29 '10 at 06:09
I also have used the oledb driver on thousands of rows, what exactly is your current issue? — James Campbell, Mar 29 '10 at 06:11
The issue is with the speed and also if the no of rows crosses 10k i get an exception which says the connection is lost. — Sudheer, Mar 29 '10 at 08:24

score 0 · Answer 1 · answered Mar 29 '10 at 06:13

0

If it is an ooxml file you can use open xml sdk. It is not as straightforward as the oledb driver, but it is possible.

If you can transform the excel-sheet to a csv-file, you can use Filehelpers. This can handle 100K+ records.

answered Mar 29 '10 at 06:13

Jelle

1 Answers1