Hi,
In the loop, I update the value I read from the excel cell in xml. But I need help on how to check if the data I read from excel cell is the value sought in xml.
For example, the XML code below does not contain the <“test”> tag. I want to check if it contains <“test”> tag.
<?xml version="1.0" encoding="ISO-8859-9"?>
<soapenv:Envelope
xmlns:soapenv="aaaaaaa"
xmlns:tem="bbbbbbbbb/">
<soapenv:Header/>
<soapenv:Body>
<ns9:getOpenInvoicesbyKeyResponse
xmlns:ns9="ccccccccccc">
<result>
<bankId>1111</bankId>
<compId>2222</compId>
<curr>3333</curr>
<errMsg>Yes</errMsg>
<invCount>4444</invCount>
<invoceList>
<anyType
xmlns:ns5="5555"
xmlns:xsi="6666" xsi:type="7777">
<controlId>8888</controlId>
<dueDate>2020311</dueDate>
<invAmount>99.99</invAmount>
<invNo>0123456789</invNo>
<invType>00000</invType>
<msisdn>9876543210</msisdn>
<nameSurname>dddddd eeeee</nameSurname>
<orderNo>88</orderNo>
<payAmount>1111</payAmount>
<period>202111</period>
<remark>000</remark>
</anyType>
</invoceList>
<msgDate>1213003550</msgDate>
<orig>
<branch>8888</branch>
<city>0</city>
<teller>1</teller>
<user>XXXX9999</user>
</orig>
<queryKey>gsmNo</queryKey>
<queryKeyValue>951753</queryKeyValue>
<respCode>00</respCode>
<stan>800111</stan>
</result>
</ns9:getOpenInvoicesbyKeyResponse>
</soapenv:Body>
</soapenv:Envelope>