Read Excel Data as a DataSet in C#

Hi,
In one of my CMS project,client need to upload data from a excel file and update that datas to our database.
First did that using Office Excel Interop.It Working in locally and in IIS also. but when i upload it to actual web site, that not working.What is the issue ? MS Office must installed in server and some settings in DCOMCNFG. Both are not posible becouse i have only ftp access. Then i search any other ways is there ? Yes i found a dll for this. Read all data as a dataset each sheet read in seperate table.So my problem solved.

I am sharing a very sample app for how to use this.

Download Source Code from github

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s