[RESOLVED] Office (excel) Import problem.

[masfenix]

just downloaded a export dataset to excel project of codeproject.

While looking at the class the import line

Imports Microsoft.Office.Interop.Excel

has a green squiggly line saying

Warning 3 Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases. C:\Users\*\Downloads\Export\Export.vb 4 9 Export

in the middle of the class in a sub i have

The two other warnings include

Warning 2 Cannot find wrapper assembly for type library "Microsoft.Office.Core". Export

Warning 1 Cannot find wrapper assembly for type library "Excel". Export

how can i solve this

[masfenix]

Solved!

WHat happened was that the path to the dll's for the office object library and office excel library were given the wrong paths. I had to re-reference them using the COM tab in "add references"

[toecutter]

I had that happin to me as well masfenix, i had to apply the lastest excel update which fixed my issue.

ps, please mark resolved

[gnxc]

Hi, i have the same error as the original poster, i am using probably the same code, too

I am at the COMS tab in add reference, but i cannot find anything relating to the "office object library and office excel library" that he mentioned.

Can anyone help? Thanks so much in advance!

[gnxc]

Bump, need help, please. =/

[toecutter]

Check the FAQ in the office forum.

Have you included the appropriate Microsoft.Office.Interop?

[gnxc]

Hmm did you mean this line: Imports Microsoft.Office.Interop.Excel?
If so, yup i have it.
Also i don't know what he means by changing the paths to dll? I can't edit any of the line in that picture you linked.

If anyone was wondering i am trying to get http://www.codeproject.com/KB/vb/Sen...ware_Eng_.aspx
to work so as to implement data export in my own windows application

EDIT: I checked up the FAQ, they only have data export from SQL Server to Excel via ADO (I'm using VB.NET)

[toecutter]

Have you actually included the Imports Microsoft.Office.Interop.Excel?
Just by adding that line didnt help me.

[toecutter]

Check out Post #3 " .NET"

*edit
Do you have any of these in your debug folder?


If not download the appropriate PIA's for your version and add them to your project.
http://www.vbforums.com/showthread.php?t=422689

[gnxc]

Ah yeah, i have none of those dll files, heh.
Thanks, I'll go try it out right now.
Also, if i am using Open Office 3.0, which PIAs should i be downloading?

And yeah i have that line in my codes already.

EDIT: I cannot find the Microsoft Office Excel, will i need MS Excel installed on my machine for this? Because i only have Open Office 3.0 Heh

[toecutter]

That i am afraid i cannot help you with as i have excel.

Have a search for "Do you need excel to reference it" or something like that...