Access Excel Interop in ASP.NET Website

Question

Hi All,

We are working on a project, which is website built using ASP.NET and C# on framework 4.5. In our project one of the key requirements is users will upload a Excel file with formatted data and the data will be saved to a SQL DB Table and processed in the web application. We have achieved this using Microsoft.OfficeInterop.Excel, this is working fine in our Dev and Testing environment, after we provided NetworkService access to the DCOM+ component "Microsoft Excel Application". 

However we are now moving it to production on a Hosted Server, and following the same procedure may not be possible as we are hosting it on Shared Hosting Service Provider. 

Is there any way we can enforce access for this component, also the hosting server environment is:

Windows 2012 R2 Standard Edition + SQL 2012 Web Edition + IIS 8.5 (ASP.net 3.5 & 4.5)

Can you kindly help us in resolving this issue at the earliest.

Thanks,

Neo

Answer 1

The two forums is where you should be posting for your issues.

http://forums.asp.net/

https://forums.iis.net/

Answer 2

You shouldn't use interop like that. Particularly not on a web server.

It's quite memory intensive and somewhat unreliable.

You ought to use open office xml instead.

Which is distributable without hosting complications.

https://msdn.microsoft.com/en-us/library/office/gg575571.aspx

---

Hope that helps.

Technet articles: WPF: MVVM Friendly User Notification; All my Technet Articles

Answer 3

Hi Andy, Thanks for the link will check on this and update.

Thanks Again,

Neo

---

Neo_NSS