Problem with Excel.Application creation

Question

0.00/5 (No votes)

See more:

I am generating excel from .net application.
In local system everything working fine.
In server system,getting error with the pages of excel code.

In server I don't have installed MS office and don't have permissions to install MS office.

Error I am getting:

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.

Source Error:

Line 39: Excel.Application objXL = new Excel.Application();

To avoid this error I have added one assembly in web.config

<add assembly="Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">

if I add this entry in web.config then it's giving me following error

could not load file or assembly 'microsoft.office.interop.excel version 11.0.0.0 culture neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system can not find the specified.

please suggest me solution for this problem

which dll's I should inculde in the bin and what other changes I need to do for this

Posted 21-Jul-11 23:08pm

pavithrap

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Dalek Dave** · Answer 1 · 2011-07-21T23:13:00

Solution 1

Not having MS Office on the server will be a problem, and are you using IIS?

It will work locally, for I assume you have Office on the machine, but when it is trying to access from the server it will run into a 'Cannot Find' situation.

Use IIS to call the Excel from your machine, or, better still, get permission and put the office suite on the server.

Posted 21-Jul-11 23:13pm

Dalek Dave

Updated 21-Jul-11 23:16pm

v2

Comments

Immaculate Perception 22-Jul-11 5:17am

Yes, agreed. Especially the Office on the Server for it has more than the main apps, it has all the connectivity.

pavithrap · Answer 2 · 2011-07-21T23:38:00

Solution 2

Thanks for your reply....

how can I call excel from IIS..?

Posted 21-Jul-11 23:38pm

pavithrap

Comments

Dave Kreskowiak 22-Jul-11 13:42pm

You're already doing it. You have to install Office on the server to get this to work. Try to remotely connect to an Office installation on another machine is problematic at best.

koolprasad2003 · Answer 3 · 2011-07-22T03:36:00

Solution 3

Either Install Office suite on server or register DLL in GAC
Put your DLL "Interop.EXCEL" in GAC (just drag and drop DLL to C:\Windows\Assembly).

Hope it helps

Posted 22-Jul-11 3:36am

koolprasad2003

Comments

Dave Kreskowiak 22-Jul-11 13:40pm

He has to have the Office Suite installed. There's no getting around that. There's no reason to use the GAC here.