ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IXMLDocument (https://www.excelbanter.com/excel-programming/431509-ixmldocument.html)

Blair Hatcher

IXMLDocument
 
Hello,
I am a bit stuck with this xml stuff as I am completely new to it.
I have created the following xml file and I want to read it in and select a
particular attribute that match's my searchstring ie "AKM2136" and return all
the nodes that are associated with it.

<?xml version="1.0" encoding="utf-8"?
<ChipParameters
<Parameter ChipName="AKM2128"
<XtalLoad7.5</XtalLoad
<XtalMinF25-20</XtalMinF25
<XtalMaxF2520</XtalMaxF25
<XtalMinAng-7.5</XtalMinAng
<XtalMaxAng7.5</XtalMaxAng
<XtalMinTS20</XtalMinTS
<XtalMaxTS40</XtalMaxTS
</Parameter
<Parameter ChipName="AKM2133"
<XtalLoad7.2</XtalLoad
<XtalMinF25-15</XtalMinF25
<XtalMaxF2515</XtalMaxF25
<XtalMinAng-10</XtalMinAng
<XtalMaxAng5</XtalMaxAng
<XtalMinTS10</XtalMinTS
<XtalMaxTS20</XtalMaxTS
</Parameter
<Parameter ChipName="AKM2136"
<XtalLoad6.9</XtalLoad
<XtalMinF25-15</XtalMinF25
<XtalMaxF2515</XtalMaxF25
<XtalMinAng-20</XtalMinAng
<XtalMaxAng0</XtalMaxAng
<XtalMinTS18</XtalMinTS
<XtalMaxTS35</XtalMaxTS
</Parameter
<Parameter ChipName="AKM2175"
<XtalLoad5.0</XtalLoad
<XtalMinF25-10</XtalMinF25
<XtalMaxF2510</XtalMaxF25
<XtalMinAng-11</XtalMinAng
<XtalMaxAng1</XtalMaxAng
<XtalMinTS14</XtalMinTS
<XtalMaxTS30</XtalMaxTS
</Parameter
</ChipParameters

In this case I want to return:

6.9
15
15
-20
0
18
35



--
Thanks for your help.

Regards
Blair


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com