xml tranformation using xsl

[candydu80]

Hi, I am new to xml so forgive me if my question is stupid. I have an xml file that I would like to read into excel with the basically the same format as xml has, tags in one column and the matching values in the next column. Is there a generic xsl codes that does this? You help is very much appreciated. My xml file is as follows:

<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl"href="transform.xsl"?>
- <cw:vessel version="1.07.0054" creationDate="2008-08-07" xmlns:cw="urnressureVessel">
- <pressureVessel>
- <revisions>
- <revision>
<revNumber>0</revNumber>
<revDate>2007-07-26</revDate>
<operator>abc</operator>
<notes>New vessel created </notes>
</revision>
</revisions>
- <generalVesselInfo>
<identifier>v77892</identifier>
<location />
<purchaser />
<service />
<tagNumber />
- <!-- Design Code Info -->
<designCode>ASME Section VIII Division 1</designCode>
<designCodeEdition>2004 A06 Addenda</designCodeEdition>
- <!-- Vessel Data -->
<units>S.I.</units>
<orientation>Vertical</orientation>
<tangentToTangentLength units="mm">5900.00</tangentToTangentLength>
<structureHeight units="mm">14674.38</structureHeight>
<outerDiameter units="mm">5140.00</outerDiameter>
<datumOffsetFrom>Bottom Shell Seam</datumOffsetFrom>
<datumOffset units="mm">0.00</datumOffset>
<datumElevation units="mm">0.00</datumElevation>
</generalVesselInfo>
</pressureVessel>
</cw:vessel>

 

[tsuji]

I would say just transform it to csv and then load it into excel. Can never say csv is out-dated!