ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reading XML node data (https://www.excelbanter.com/excel-programming/390861-reading-xml-node-data.html)

Zarch

Reading XML node data
 
Hi,

I have a situation where I need to count the number of records in an xml
file, then loop through the file and import the data from one node (called
'Day' which contains two fields 'Date' and 'Quantity' each holding 20 items
of data) for each record, importing the data into two lists on a worksheet
and then performing data manipulation on the returned data before clearing
the imported lists and reading the node data for the next record. The node is
about five levels down in the xml structure.

Any help much appreciated.

Kind regards,

Mark



All times are GMT +1. The time now is 01:43 PM.

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