Proble With XSLT Program

Former Member — Thu, 23 Apr 2009 07:22:13 GMT

I have created a XSLT Program for an abap internal table.by using the foolowing code

CALL TRANSFORMATION z_mm__xls

SOURCE root = gt_po_data

RESULT XML gv_xml_result.

after this when i tried to download to presentation server using FM *cl_gui_frontend_services=>gui_download* i am unable to get the contents in excel.

Please find my XSLT code below

<tt:transform xmlns:tt="http://www.sap.com/transformation-templates">

<tt:root name="ROOT"/>

<tt:template>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=

"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">

<Font/>

</STYLE>

</STYLE>

</STYLE>

</STYLES>

<NAMES>

</NAMES>

<TABLE>

<ROW>

<CELL>

</CELL>

<Cell>

</Cell>

<Cell>

<Data ss:Type="String">Special stock</Data>

</Cell>

<Cell>

</Cell>

<Cell>

<Data ss:Type="String">Sched.Agr.</Data>

</Cell>

<Cell>

<Data ss:Type="String">Cust.material</Data>

</Cell>

<Cell>

<Data ss:Type="String">MRP Material</Data>

</Cell>

<Cell>

<Data ss:Type="String">Plant</Data>

</Cell>

<Cell>

<Data ss:Type="String">Finishing line</Data>

</Cell>

<Cell>

</Cell>

<Cell>

<Data ss:Type="String">Alignment date</Data>

</Cell>

<Cell>

</Cell>

<Cell>

</Cell>

<Cell>

</Cell>

<Cell>

<Data ss:Type="String">Ordered Quantity</Data>

</Cell>

<Cell>

<Data ss:Type="String">Cml.released qty</Data>

</Cell>

<Cell>

<Data ss:Type="String">Quantity to be Delivered</Data>

</Cell>

<Cell>

<Data ss:Type="String">Quantity to be Produced</Data>

</Cell>

<Cell>

</Cell>

<Cell>

<Data ss:Type="String">Last Material Ref.Millr</Data>

</Cell>

<Cell>

<Data ss:Type="String">Cons. Stock</Data>

</Cell>

<Cell>

<Data ss:Type="String">Stock on wheels</Data>

</Cell>

<Cell>

<Data ss:Type="String">Reshipper stock</Data>

</Cell>

<Cell>

<Data ss:Type="String">Plant Stock</Data>

</Cell>

<Cell>

<Data ss:Type="String">Thickness</Data>

</Cell>

<Cell>

<Data ss:Type="String">Width</Data>

</Cell>

<Cell>

<Data ss:Type="String">Length</Data>

</Cell>

</ROW>

<tt:loop name="line" ref=".ROOT">

<Row>

<Cell>

<tt:value ref="$line.soldto"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.shipto"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.specil"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.endusr"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.vbeln"/>

</Data>

</Cell>

<tt:value ref="$line.kdmat"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.matnr"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.werks"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.zzpp16"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.cydat"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.aldate"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.lrdate"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.week"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.date"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.ordqty"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.cumqty"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.delqty"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.proqty"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.meins"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.lmatnr"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.consi"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.stock"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.reshi"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.pstock"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.zzdi03"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.zzdi06"/>

</Data>

</Cell>

<Cell>

<tt:value ref="$line.zzdi09"/>

</Data>

</Cell>

</Row>

</tt:loop>

</TABLE>

<Panes>

<Pane>

</Pane>

</Panes>

<ProtectObjects>False</ProtectObjects>

<ProtectScenarios>False</ProtectScenarios>

</WorksheetOptions>

</Worksheet>

</Workbook>

</tt:template>

</tt:transform>

Kindly help me to solve my problem..

topic Re: Proble With XSLT Program in Application Development and Automation Discussions

Proble With XSLT Program

Re: Proble With XSLT Program

Re: Proble With XSLT Program