The type or namespace name 'Excel' could not be found

pmcm

Hi everyone, I'm working in VS2010 and trying to create an app that interacts with Excel. I've added The MS Excel 14.0 Object Library reference (COM Tab) and at the top of my code I have the following:

using Microsoft.Office.Interop;
using Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Word;

I've tried to do:

var x1 = new Excel.Application();

and I get the error. My project is .Net framework 4. I've tried to find an answer on Google and did what was suggested on a few other forums but still this is not working for me anyone any ideas why?

Lost User

pmcm wrote:

var x1 = new Excel.Application();

try: var x1 = new Microsoft.Office.Interop.Excel.Application();

Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Individuality is fine, as long as we do it together - F. Burns

pmcm

your suggestion worked but instead of doing that every time throughout my code I've set this up:

using Excel = Microsoft.Office.Interop.Excel;

any idea why my project doesn't seem to be picking up the references that I added? Thanks

Lost User

This is the correct way to do it, as described here[^].

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

Luc Pattyn

when you do

using some1.some2.some3;

then the C# compiler will add "some1.some2.some3" to the list of known prefixes, which it uses to locate a type. Therefore,

using System.Windows.Forms;
...
Form f=new Form(); // works as the full type name is System.Windows.Forms.Form
Forms.Form f2=f; // doesn't work as now prefixing System.Windows.Forms would result in a double "Forms"

:)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Fed up by FireFox memory leaks I switched to Opera and now CP doesn't perform its paste magic, so links will not be offered. Sorry.

Lost User

That doesn't work in .NET 2.0+, since you can't prefix a class name with a "part" of the namespace like that.

Bastard Programmer from Hell :suss:

Dinesh92

i think you should use "Add reference", right click on form->Add reference, there you will get all the namespace which are available. :)

Lost User

OP is using .NET 4.0.

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

pmcm

I've added the MS Excel 14.0 Object Library reference (COM Tab), Richard the link that you have recommended is one that I have already followed but I was still getting the error.

Lost User

Shouldn't work in 4.0 either, but I'm too lazy to give it a try right now :)

Bastard Programmer from Hell :suss:

Lost User

Eddy Vluggen wrote:

Shouldn't work in 4.0 either

I've used it in 3.0 and it worked fine. Did you read the linked article I referred to?

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

Lost User

That tells us that you have probably used VB to implement the example, as C# doesn't allow a prefix of the classname with a partial namespace;

Namespace Mine.Test
Public Class SomeClass
Public Property P As Guid
End Class
End Namespace

--

Imports ScratchVb.Mine

Module Module1
Sub Main()
' VB.NET allows you to use "a part" of the namespace as a prefix
Dim X As Object = New Test.SomeClass()
End Sub
End Module

using System;
namespace Mine.Test
{
class SomeClass
{
public Guid P { get; set; }
}
}

--

using Mine;

namespace Scratch
{
class Program
{
static void Main(string[] args)
{
// Prefixing a part of the name isn't allowed
Object X = new Test.SomeClass();
// Full namespace is allowed, of course;
Object X = new Mine.Test.SomeClass();
}
}
}

Yes, read the article some time ago. Did you try it? :)

Bastard Programmer from Hell :suss:

Lost User

Eddy Vluggen wrote:

That tells us that you have probably used VB to implement the example, as C# doesn't allow a prefix of the classname with a partial namespace;

Wrong on both counts.

Eddy Vluggen wrote:

Yes, read the article some time ago. Did you try it?

Yes I tried it, using C# as i)I never use or have used VB/VB.NET and ii)the title of the article is How to automate Microsoft Excel from Microsoft Visual C#.NET!

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

Lost User

pmcm wrote:

Richard the link that you have recommended is one that I have already followed but I was still getting the error.

Can you show your code and the exact text of the error message?

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

Lost User

Richard MacCutchan wrote:

Yes I tried it, using C#

Never mind :)

Bastard Programmer from Hell :suss:

Lost User

Eddy Vluggen wrote:

Never mind

I don't mind, it's you that kept banging on about it, like a :mad:

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

pmcm

I fixed this issue by doing:

using Microsoft.Office.Interop;
using Excel = Microsoft.Office.Interop.Excel;
using Word = Microsoft.Office.Interop.Word;

Lost User

That's what I suggested yesterday.

Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman