0

What's the best library to read Excel files, I used ExcelDataReader and it seems dealing only small sizes < 1mo.

Any suggestion ?

shA.t
  • 16,580
  • 5
  • 54
  • 111
Mirtov
  • 77
  • 11
  • 1
    Look here: http://stackoverflow.com/questions/12300915/what-is-the-c-sharp-equivalent-of-apache-poi-api – Bor Laze May 13 '17 at 18:11
  • 1
    Do you have a sample Excel file that I can use to reproduce this issue? It's been reported before, https://github.com/ExcelDataReader/ExcelDataReader/issues/193, but so far we haven't been able to reproduce it. – Johan Appelgren Jul 07 '17 at 20:10
  • [Link to Excel file](https://docs.google.com/spreadsheets/d/1S_7Q5MC30IgT8ziVMfUJvQrtyrTvmPx5fhDoKWcgaNk/edit?usp=drive_web) – Mirtov Aug 15 '17 at 13:25
  • Why do you want to read an Excel file? You can connect it like a database with a connection string by using oledb or ... ;). – shA.t Sep 03 '17 at 11:00
  • @shA.t thanks for your reply, i've compared some excel files to each others with using some libraries in order to facilitate my task. – Mirtov Sep 04 '17 at 03:01
  • 1
    Consider reading huge data from Excel by using Excel-Helpers will not give you a good performance; instead will give you some features like in Excel, If you want to to read data and compare them or any other data analyzing, use Excel data like a Database ;). – shA.t Sep 04 '17 at 06:40

0 Answers0