Reading an Excel worksheet containing 10,000 rows in C #

Question

Possible duplicate:
Reading Excel files as a server process

While the Jet OleDB driver is fairly easy to use to read an Excel worksheet, it simply cannot process excel files with lines of more than a thousand.

Is there any other way to read more than 5-10 thousand lines from an excel sheet in C #?

Answer 1

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

If you can convert the excel list to a csv file, you can use Filehelpers . It can handle 100K + records.