Read Excel Data as a DataSet in C#

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

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s