Import Excel Data to DataTable and display in grid in C#, ASP.NET - CodeProject
The example shows how you can directly import full excel sheet into a data table in c#. I have created example of same with importing both *.xls & *.xlsx file. the common problem when using this method will be "The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine". I also have added solution for same.
Continue Reading http://www.codeproject.com
Join the Discussion