Name space problem in .net 2005

Question

0.00/5 (No votes)

See more:

Hi All,

I m using .net 2005 i m trying to put name space
using Excel;
for excel datasheet import and export in my application but it is showing error in name space.
what should I do ?
Please help

Thanks & regards
Indrajit dasgupta

Posted 26-Apr-11 20:44pm

IndrajitDasgupat

Add a Solution

Comments

Ankit Rajput 27-Apr-11 2:45am

Can you please provide the error detail.

4 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)

Abhinav S · Answer 1 · 2011-04-26T20:48:00

Solution 2

You probably need to include a reference to the Excel Interop dll (Microsoft.Office.Interop.Excel.dll).

Posted 26-Apr-11 20:48pm

Abhinav S

v2

Comments

Sergey Alexandrovich Kryukov 27-Apr-11 3:00am

It's good you mention DLL (you should have said assembly; moreover, in CAG is it not named by DLL... because it's strongly named). My 5.

Also, name space can be retrieved using VS.

I explain that in general terms, please see my answer.
--SA

Ankit Rajput · Answer 2 · 2011-04-26T20:49:00

Solution 3

Hi,

You can try one thing
use this syntax

using Microsoft.Office.Interop.Excel;

For this you need to add refrence of
"Microsoft.Office.Interop.Excel"

Regards
AR

Posted 26-Apr-11 20:49pm

Ankit Rajput

Comments

Abhinav S 27-Apr-11 2:49am

He also needs to add a reference to the dll.

Ankit Rajput 27-Apr-11 2:53am

I have already maintioned the Refrence name.
Only the difference is, I have maintioned it as .Net will show you

Sergey Alexandrovich Kryukov 27-Apr-11 3:02am

Best answer so far (mine, too :-) because you mention assembly and not DLL (important for CAG).
Also, name space can be retrieved using VS.

I explain that in general terms, please see my answer.
--SA

Ankit Rajput 27-Apr-11 5:00am

thanks

Sergey Alexandrovich Kryukov · Answer 3 · 2011-04-26T20:51:00

There are no any problems with any name spaces in any version of .NET.

The only problem is failure to reference assemblies required by your project. Usually, when a compilation fails, it tells you what assembly should you add to the reference list of your project. It is not the case if it is not the GAC assembly or a registered COM component.

The assembly you need is in GAC, its name is "Microsoft.Office.Interop.Excel".

[EDIT]
(Ankit mentioned it.)

When an assembly reference is added, click on its node in Project Explorer. It opens the tree of references where you can browse and find out your name spaces. Use what you need in "using".

—SA

OriginalGriff · Answer 4 · 2011-04-26T20:48:00

Solution 1

Try:

using Microsoft.Office.Interop.Excel;

Posted 26-Apr-11 20:48pm

OriginalGriff

Comments

Sergey Alexandrovich Kryukov 27-Apr-11 2:58am

You should have mentioned the assembly first of all, as others did. Name space can be found when it is referenced.
I explain that in general terms, please see.
--SA

OriginalGriff 27-Apr-11 3:04am

You are probably right, I should have suggested adding a reference first.

Name space problem in .net 2005

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us