I need an alternative for an Office automation initiated in an ASP.NET page. Because of the below disclaimer I can't use the Microsoft.Office.Interop.Excel class:
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
Is there an alternative to this?
I know I could try the Open XML but that seems more complicated than it should be ... All I need to do is open an Excel workbook on the server and format a number of spreadsheets.
I am considering a webservice consumer on the server; working locally with Microsoft.Office.Interop.Excel shouldn't be a problem. Would this be a good alternative?
Could anybody point to an example?
Thanks a bunch,
View Complete Post