I would not automate any office program from a website. You could wind up with hundreds of instances of office running at one time causing issues on the web server. I would use a third party class library like aspose cells or the open source npoi to create
the excel document
Ken Tucker
All-Star
16797 Points
2608 Posts
MVP
Re: Session Clears Out, after using Microsoft.Interop.Excel etc
Feb 14, 2012 10:26 AM|LINK
I would not automate any office program from a website. You could wind up with hundreds of instances of office running at one time causing issues on the web server. I would use a third party class library like aspose cells or the open source npoi to create the excel document
http://code.google.com/p/npoi/
Space Coast .Net User Group