Nuget package to read excel (all versions)

Question

User1284890338 posted

Hi All,

Which is the best nuget package to read excel (any version) data, so that i can insert it to database table.

Any specific libraries that support this functionality?

Thanks

Answer 1

User-1838255255 posted

Hi Harry US11,

According to your needs, i think you could check the following package, like this: 

ExcelDataReader: 

https://www.nuget.org/packages/ExcelDataReader 

Also you could check this tutorial then select a suitable package:

http://nugetmusthaves.com/Tag/Excel 

Best Regards,

Eric Du 

Answer 2

User-1599850035 posted

Try Spire.XLS, it supports excel version  2007 -2016, and it provides a straightforward method - Worsheet.ExportDataTable to export data from worksheet to datatable.

https://www.nuget.org/packages/Spire.XLS/