Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
position() in XmlDataQuery
In Excel 2003 Professional, is it possible to do the following using
XmlDataQuery - ie: use the "position()" function in the XPath: CType(ThisWorkbook.Worksheets(1), Excel.Worksheet).XmlDataQuery("/Doc/LineItem[position()=1]/Field") Where the XML in the map is: <Doc <Stuff/ <MoreStuff/ <LineItem <FieldFirstField</Field </LineItem <LineItem <FieldSecondField</Field </LineItem </Doc And have it return the cell for the "SecondField "? The XmlDataQuery always throws an exception for me. The reason I ask is because I need to find the cell and change it's background colour. I only have the XML available, and it's the XML that's telling me which cell to modify. Thanks, d |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using position() in XmlDataQuery | Excel Programming | |||
Using position() in XmlDataQuery | Excel Programming | |||
Using position() in XmlDataQuery | Excel Discussion (Misc queries) | |||
I am getting a error with XmlDataQuery | Excel Programming | |||
XmlMapQuery and XmlDataQuery Samples in Excel 2003 and VB.NET | Excel Programming |