Map this!
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)? |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com