I have a requirement to convert the XML files to Excel. So i want to retrieve the XML as name value pairs and uniquely name the columns.
Is there any method to get the XML array index of a node ? Below is the sample XML where i want to know the index of productInfo fields.
<productInfoRequest>
<CheckIn>false</doCheckIn>
<timeStamp>2016-11-02T15:49:57.337-05:00</timeStamp>
<foodoInfo>
<Country>USA</receiveCountry>
<Currency>USD</Currency>
</fqdoInfo>
<productInfo>
<itemNo>1</itemNo>
<itemName>Sample</itemName>
</productInfo>
<productInfo>
<itemNo>2</itemNo>
<itemName>Sample</itemName>
</productInfo>
<productInfo>
<itemNo>3</itemNo>
<itemName>Sample</itemName>
</productInfo>
<productInfo>
<itemNo>4</itemNo>
<itemName>Sample</itemName>
</productInfo>
</productInfoRequest>