Xml To Excel Conversion Using Xslt

[vikasthukral17]

Hello Friends
i want to convert xml shown under into excel file,xml is as


<?xml version="1.0" standalone="yes "?>
<?xml-stylesheet type="text/xsl" href="AggrPosit ions.xsl"?>
<DataOut>
<NoName>
<AggregatedPosi tion>
<PositionRefere nce>549</PositionReferen ce>
<ProductIdentif ier>DKK</ProductIdentifi er>
<ProductDescrip tion>DANISH KRONER</ProductDescript ion>
</AggregatedPosit ion>
<AggregatedPosi tion>
<PositionRefere nce>575</PositionReferen ce>
<ProductIdentif ier>BG/ LN Equity</ProductIdentifi er>
<ProductDescrip tion>BG GROUP PLC</ProductDescript ion>
</AggregatedPosit ion>
</NoName>
<Personal_And_H ousehold>
<AggregatedPosi tion>
<PositionRefere nce>52</PositionReferen ce>
<ProductIdentif ier>BATS LN Equity</ProductIdentifi er>
<ProductDescrip tion>BRITISH AMERICAN TOBACCO</ProductDescript ion>
</AggregatedPosit ion>
</Personal_And_Ho usehold>
<Oil_Service>
<AggregatedPosi tion>
<PositionRefere nce>27</PositionReferen ce>
<ProductIdentif ier>PRS NO Equity</ProductIdentifi er>
<ProductDescrip tion>PROSAFE ASA NOK10</ProductDescript ion>
</AggregatedPosit ion>
<AggregatedPosi tion>
<PositionRefere nce>23</PositionReferen ce>
<ProductIdentif ier>AKSO NO Equity</ProductIdentifi er>
<ProductDescrip tion>AKER KVAERNER</ProductDescript ion>
</AggregatedPosit ion>
</Oil_Service>
<Utility>
<AggregatedPosi tion>
<PositionRefere nce>405</PositionReferen ce>
<ProductIdentif ier>ENG SM Equity</ProductIdentifi er>
<ProductDescrip tion>ENAGAS</ProductDescript ion>
</AggregatedPosit ion>
<AggregatedPosi tion>
<PositionRefere nce>527</PositionReferen ce>
<ProductIdentif ier>SXXP Index</ProductIdentifi er>
<ProductDescrip tion>DJ STOXX 600 = Pr EQUITY INDEX INDEX 0.0</ProductDescript ion>
</AggregatedPosit ion>
</Utility>
</DataOut>







i want to convert it into Excel using xslt


Excel format is as



Group PositionReferen ce ProductIdentifi er ProductDescript ion
NoName, 549 DKK DANISH KRONER
Personal_And_Ho usehold
Oil_Service
Utility


hhere group is NoName,Personal _And_Household, (tag containing aggregated positions) and rest is tagswithin AggregatedPosit ion




can any body give me xslt idea for my problem, any thing want to ask plz ask me on vikasthukral17@ gmail.com



plz help out for my problem thanks in advance