Read Excel sheet to datatable

[Anonymous]

Hi,

I want to read an Excel sheet into a datatable. But I cannot go forward as it gives me an error, as follows.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

What is the other option?

Thanks

[fieldguy]

https://msdn.microsoft.com/en-us/library/office/bb448854.aspx

[Keith.Brown · Accepted solution]

You can use spreadsheet lite.  It is a free sdk for working with spreadsheets in .net.

http://spreadsheetlight.com/

Example of exporting to a datatable.  See the pic for the link.

http://spreadsheetlight.com/sample-code/