The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)

Question

3.50/5 (2 votes)

See more:

Hi Friends

I am stuck up with a problem.I would be grateful to you people if anyone of you help mein solving my problem.

Actually I want to invoke an Excel application through my C# .Net program.For that I added the

using Excel= Microsoft.Office.Interop.Excel;

For that I did as below-->

My application->RC->Add Referenece->COM->Microsoft Excel 12.0 Object Library.

I did not find Microsoft.Office.Interop.Excel;

Now at Complie time I am getting a error as-->

The type or namespace name 'Office' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)

Am I missing anything or doing something wrong?
Can anybody help me for solving this problem??

Thanking in Advance.

Swapnil Borkar
(Software Trainee)

Posted 9-Mar-10 19:12pm

Swapnil 2009

Updated 9-Mar-10 19:40pm

v2

Add a Solution

4 solutions

Solution 3

VB

AddReference->.NET->
Microsoft.Office.Interop.Excel.

Posted 1-Mar-12 1:31am

RamkumarS.N.

Solution 1

I don't think you want to add a reference to the COM library if you're using C#. You want the Primary Interop Assemblies, but you'll have to check the MSDN documentation for where to find them. I think their presence also depends on the version of Visual Studio you're using (I don't think the Express editions include them, for example).

A good place to start might be creating an Office plug-in project in Visual Studio and seeing what the references end up being.

Altenrativly, have a look in Object Browser to see what namespace the Excel Object Library has been put in. Be warned, however, that this is not the recommended way of doing things.

Posted 9-Mar-10 22:43pm

Tony Richards

Solution 5

Add the "Microsoft.Office.Interop.Excel.dll" to your C# project reference from the following path

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Visual Studio Tools for Office\PIA\Office14\Microsoft.Office.Interop.Excel.dll

Posted 9-Aug-12 11:18am

Liwei Xu

Updated 9-Aug-12 11:21am

v2

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)

Richard MacCutchan · Accepted Answer · 2010-03-10T00:08:00

Solution 2

You need also to add a reference to the Microsoft Office 12.0 Object Libray, for the base support for office interop. See this article[^] for more information.

Posted 10-Mar-10 0:08am

Richard MacCutchan

Updated 10-Mar-10 0:09am

v2