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.