Click here to Skip to main content
15,897,718 members

Problem with Excel.Application creation

pavithrap asked:

Open original thread
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
Tags: C#, ASP.NET

Plain Text
ASM
ASP
ASP.NET
BASIC
BAT
C#
C++
COBOL
CoffeeScript
CSS
Dart
dbase
F#
FORTRAN
HTML
Java
Javascript
Kotlin
Lua
MIDL
MSIL
ObjectiveC
Pascal
PERL
PHP
PowerShell
Python
Razor
Ruby
Scala
Shell
SLN
SQL
Swift
T4
Terminal
TypeScript
VB
VBScript
XML
YAML

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
  4. 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.
Please note that all posts will be submitted under the http://www.codeproject.com/info/cpol10.aspx.



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900