Thursday, November 7, 2013

How to import Data from Excel files to Dataset in .Net

Hi,

I want to share a path to import Excel files in .Net.

It is easy to export data to excel from our Grids in .Net(at least we know it very well) but importing data from Excel,it is troublesome task for us.

Naturally we do read through OLEDB, but is slow and troublesome.
To get rid off all these difficulties, we can access(/download) a Codeplex dll,it will read all the data(huge data also) within no time from  excel files into Dataset.

I am just mentioning link below

https://exceldatareader.codeplex.com/


go there and download that package and follow simple instructions(/simple code) to access the excel data,

that will works.

kudos to codeplex and people of Excel Data Reader


Thanks,
Hari



No comments:

Post a Comment