Import XML Data
 

Hi

I have a workbook which is used to define a report by allowing users to pick
field names from a list and specifying filters using drop down boxes, the
system then calls a webservice which returns an XML file containing the
report.

The trouble is that because the report fields are dynamic i cant place a map
on a worksheet to import the data into because i dont have a schema at
design time.

I can create a map on the fly but i dont know how to get that map onto a
sheet for importing the data.

I have control over the report generation so i can get the XML in whatever
format i like, so far i have tried the following 2 ways (See below).

Thanks
Ben

1. I cant get this to work as its to static
<data
<row
<Field1value</Field1
<Field1value</Field1
<Field1value</Field1
</row
<row
<Field1value</Field1
<Field1value</Field1
<Field1value</Field1
</row
<data

2. I cant get this to display the results correctly
<data
<row
<value name="Field1"value</value
<value name="Field2"value</value
<value name="Field3"value</value
</row
<row
<value name="Field1"value</value
<value name="Field2"value</value
<value name="Field3"value</value
</row
<data