I have an xml that goes like the following:
<root
<inv
<date01/01/2006</date
<siteSite_1</site
<initial_quantity250</initial_quantity
<final_quantity150</final_quantity
</inv
<inv
<date01/02/2006</date <!-- next date --
<siteSite_1</site <!-- Same site --
<initial_quantity175</initial_quantity
<final_quantity75</final_quantity
</inv
<!-- and so on for next 10 or so days --
<!-- same as above for some other site --
</root

I can create an xsd for this.

How do I map it to excel (xml map) so that the individual dates appear in
COLUMNS? Basically, the column heading should appear like the following in
Excel:
"Site", "Quantity Type", "01/01/2006", "01/02/2006", ... are the column
titles.
Under "Site" title, I need to show the site_1....
In 2nd column I need to show text "Initial Quantity" in first row, and
"Final Quantity" in 2nd row.. then under "01/01/2006" column, I need to show
250 and 175 respectively, and under 01/02/2006 column I need to show 150 and
75 respectively for Initial and Final quantities.

Site Quantity Type 01/01/2006 01/02/2006 ....
site_1
Initial Quantity 250 175
Final Quantity 150 75

How I do map the xsd that matches the above xml to be displayed like above
(and keeping the cells to be editable)?