How to use c# to access the names that defined in excels?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marxi - 31 Jan 2007 01:21 GMT

Hi:
I would like to use c# to access the names that defined in components
axspreedsheet. But I can not accomplish. why? the code like the followings:
System.Collections.IEnumerator myEnumerator =
Spreadsheet1.Names.GetEnumerator();
Console.WriteLine("The Array contains the following
values:");
int i = 0;
while ((myEnumerator.MoveNext()) && (myEnumerator.Current !=
null))
Console.WriteLine("[{0}] {1}", i++,
myEnumerator.Current);

the results only list "System._ComObject". why?
Is it can not access just because the type is protected?

Signature

Happy Everyday!

Reply to this Message

Ciaran O''Donnell - 31 Jan 2007 13:35 GMT

The enumerator you are using is not returning strings to you. It is returning
an object (probably of type name). I would suggest looking at the object in
the debugger and seeing what property it may have to access the name.

Signature

Ciaran O''Donnell
http://wannabedeveloper.spaces.live.com

> Hi:
> I would like to use c# to access the names that defined in components
[quoted text clipped - 11 lines]
> the results only list "System._ComObject". why?
> Is it can not access just because the type is protected?

Reply to this Message

marxi - 02 Feb 2007 01:15 GMT

I know it is a Object type. But it located at final level. It has no
property. How can i access to it?

Signature

marxi

> The enumerator you are using is not returning strings to you. It is returning
> an object (probably of type name). I would suggest looking at the object in
[quoted text clipped - 15 lines]
> > the results only list "System._ComObject". why?
> > Is it can not access just because the type is protected?

Reply to this Message

marxi - 03 Feb 2007 04:35 GMT

can you helpl me? this problem have confused me many days! thank you very much!

Signature

marxi

> I know it is a Object type. But it located at final level. It has no
> property. How can i access to it?
[quoted text clipped - 18 lines]
> > > the results only list "System._ComObject". why?
> > > Is it can not access just because the type is protected?

Reply to this Message

How to use c# to access the names that defined in excels?

Free Magazines