Reading an Excel Sheet containing 10000 Rows In C# [duplicate]

This question already has answers here: Closed 10 years ago.

Possible Duplicate:

Reading Excel Files as a Server Process

While the Jet OleDB 开发者_C百科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#?

---

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.