Help: How to Get Fields Mapped (using .Net ?

[Guest]

I Built an excel file,
using XmlWebReference

and my result is

+-----------+-----------+
| Field1 v | Field 2 v|
+-----------+-----------+
|Value 1 |
|Value 2 |
|Value 3 |
+-----------+-----------+

Now I Need to get
the list of Fields mapped
using Net

I tried with

Excel.ActiveWorkBook.Maps(1).Schemas(1).... (Vb)

Excel.ActiveWorkBook.Maps[1].Schemas[1].... (c#)

i Tried also in Excel Visual Basic Editor
but failed

please help me!!!


Thank in advance

 

[William Ryan eMVP]

Ales:

Are you in .NET environment or Excel. If .NET, what exception are you
getting.

 

[Guest]

I found Field List in
Excel.ActiveWorkBook.Maps[1].Schemas[5]

but how to get
Map on sheet

I need to know

Field1 is mapped starting from A10,
Field2 is mapped starting from C10,
Field3 is Mapped starting from B10

ad so on

Thanks in advance

Search List
Mapping, Com, interoperabilty, .net
Field

Are you in .NET environment or Excel. If .NET, what exception are you
getting.

I Built an excel file,
using XmlWebReference

and my result is

+-----------+-----------+
| Field1 v | Field 2 v| +-----------+-----------+
|Value 1 |
|Value 2 |
|Value 3 |
+-----------+-----------+

Now I Need to get
the list of Fields mapped
using Net

I tried with

Excel.ActiveWorkBook.Maps(1).Schemas(1).... (Vb)

Excel.ActiveWorkBook.Maps[1].Schemas[1].... (c#)

i Tried also in Excel Visual Basic Editor
but failed

please help me!!!


Thank in advance

 

[Guest]

I found The list Of Fields in
Excel.ActiveWorkBook.Maps(1).Schemas(5).Xml

And Found The mapping

in

dim oRange as Range
strXPath="/ns1ataSet/ns3:diffgram/GetDataSet/Table/" + strColName
set oRange=oWB.Worksheets[1].XmlMapQuery(strXPath)

how is explaned in

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_xlexpen.asp