Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Our application is using Excel Automation technique to create objects , It working fine up to few instance and when the load increase on IIS then excel instance fails to create the object

Our Hosting server Windows 2008 R2 64 bit.

share|improve this question
 
Can you check whenever multiple instances of Excel are open? It might be that the COM object isn't properly closed. –  Measuring 23 hours ago
1  
Don't use Excel on a server: support.microsoft.com/kb/257757 –  John Koerner 23 hours ago
 
Welcome to Stack Overflow! It is a horrible idea to use Office Interop from ASP.NET or another server technology. These APIs were written for use in a desktop application, for automating Office (a suite of desktop applications). Server applications are different in many ways that make it a very, very bad idea to use Office Interop in them. It's also unsupported by Microsoft, and may violate your Office license. See Considerations for server-side Automation of Office –  John Saunders 23 hours ago
 
As John said, don't try to use Excel in a web application, you'll be making a rod for your own back for the lifetime of the app. Get your employer or client to buy something like Aspose Cells for .NET: aspose.com/.net/excel-component.aspx . At first glance it may look expensive, but it'll save you days of problems. –  Kev 19 hours ago

put on hold as off-topic by MichaC, Kev, John Saunders, Ahmed Siouani, Kjartan 9 hours ago

This question appears to be off-topic. The users who voted to close gave these specific reasons:

  • "Questions concerning problems with code you've written must describe the specific problem — and include valid code to reproduce it — in the question itself. See SSCCE.org for guidance." – MichaC, Kjartan
  • "Questions asking for code must demonstrate a minimal understanding of the problem being solved. Include attempted solutions, why they didn't work, and the expected results. See also: Stack Overflow question checklist" – Kev, John Saunders, Ahmed Siouani
If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged or ask your own question.