error while creating excel file in c# webapplication

Question

i am getting following error while creating the excel file

System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)). at QA.CreateExcel.createDoc() in e:\~~CreateExcel.cs:line 33

i am using this code.

private Office.Excel.Application app =new Office.Excel.Application();

m using fw 4.0 and its a webapplication

Do not automate excel in a web application. It won't work well. — SLaks
– SLaks, Commented Feb 24, 2011 at 12:36
support.microsoft.com/kb/257757 And, there are other options. — SLaks
– SLaks, Commented Feb 24, 2011 at 12:48
There are several libraries that allow you to produce and read Excel and other office documents without office. — C. Ross
– C. Ross, Commented Feb 24, 2011 at 13:17

David · Accepted Answer · 2011-02-24 13:04:12Z

2

Office 2007/2010 file formats are XML files wrapped inside of zips and can be created server-side without needing Office installed. Some searching online will reveal solutions for simplifying the task of doing so.

For example, Codeplex has a project that makes doing so almost as easy as automating Excel, but with none of the issues you are encountering.

http://www.codeproject.com/KB/office/ExcelPackage.aspx

answered Feb 24, 2011 at 13:04

David

2291 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Willem · Accepted Answer · 2011-02-24 13:42:46Z

0

Well, install Excel on the server and give IIS the rights to use it. This will not be stable, and chances are that your hosting provider won't even let you (unless you are hosting it on your own servers). This would also cost you an Office license..

Microsoft advises against installing Office on servers because of stability and reliability issues. http://support.microsoft.com/kb/257757 focusses on some of these problems and also mentions some alternatives.

answered Feb 24, 2011 at 13:42

Willem

5,4042 gold badges25 silver badges44 bronze badges

Collectives™ on Stack Overflow

error while creating excel file in c# webapplication

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related