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

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

How to Get Fields Mapped (using .Net ?
 

Ales:

Are you in .NET environment or Excel. If .NET, what exception are you
getting.
"ales no spam" wrote in message
om...
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

How to Get Fields Mapped (using .Net )?
 

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.
"ales no spam" wrote in message
om...
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

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

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

And Found The mapping

in

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

how is explaned in

http://msdn.microsoft.com/library/de...dc_xlexpen.asp


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