<?sap.transform simple?>

tt:transform xmlns:tt="http://www.sap.com/transformation-templates" xmlns:ddic="http://www.sap.com/abapxml/types/dictionary"

xmlns:def="http://www.sap.com/abapxml/types/defined">

<!--SAPYard Tip-->

<!--* This is like your data declaration-->

<tt:root name="TABLE" type="?"/>

<tt:root name="VARIABLES" type="?"/>

<tt:root name="WORKAREAS" type="?"/>

<!--SAPYard Tip-->

<!--* Add all your extra work areas, variables tables here onwards -->

<tt:template

<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:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html=

"http://www.w3.org/TR/REC-html40">

<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

<Author>Yard, SAP</Author>

<LastAuthor>Yard, SAP</LastAuthor

<Created>2014-11-04T20:56:46Z</Created>

<LastSaved>2014-01-24T20:55:32Z</LastSaved

<Version>14.00</Version>

</DocumentProperties

<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

<DownloadComponents/>

<LocationOfComponents HRef="file:///\\msowc.cab"/>

</OfficeDocumentSettings

<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

<WindowHeight>12660</WindowHeight

<WindowWidth>19980</WindowWidth

<WindowTopX>480</WindowTopX

<WindowTopY>120</WindowTopY

<ProtectStructure>False</ProtectStructure

<ProtectWindows>False</ProtectWindows

</ExcelWorkbook

<!--SAPYard Tip-->

<!--* You need to define all your styles here-->

<Styles>

<!--SAPYard Tip-->

<!--* Style 1 -->

<Style ss:ID="Default" ss:Name="Normal">

<Alignment ss:Vertical="Bottom"/>

<Borders/>

<Font ss:FontName="Arial"/>

<Interior/>

<NumberFormat/>

<Protection/>

</Style>

<!--SAPYard Tip-->

<!--* Style 2 -->

<Style ss:ID="m31454304">

<Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>

<Borders>

<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>

<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>

<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>

<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>

</Borders>

<Font ss:Bold="1" ss:FontName="Arial" x:Family="Swiss"/>

<Interior ss:Color="#FFFF99" ss:Pattern="Solid"/>

</Style>

<!--SAPYard Tip-->

<!--* Style 3 and so on -->

<Style ss:ID="m31454080">

<Alignment ss:Vertical="Bottom"/>

<Borders>

<Border ss:LineStyle="Continuous" ss:Position="Bottom" ss:Weight="1"/>

<Border ss:LineStyle="Continuous" ss:Position="Left" ss:Weight="1"/>

<Border ss:LineStyle="Continuous" ss:Position="Right" ss:Weight="1"/>

<Border ss:LineStyle="Continuous" ss:Position="Top" ss:Weight="1"/>

</Borders>

<Font ss:Bold="1" ss:FontName="Arial" x:Family="Swiss"/>

<Interior ss:Color="#FFFF99" ss:Pattern="Solid"/>

</Style>

<!--SAPYard Tip-->

<!--* Add all your extra styles here onwards -->

</Styles>

<!--SAPYard Tip-->

<!--* Styles definition ends above -->

<!--SAPYard Tip-->

<!--* Name your worksheet here-->

<Worksheet ss:Name="SAP Yard excel download">

<!--SAPYard Tip-->

<!--* Define how many Columns and Rows you expect in excel. Just give some maximum number like 100 column 66625 columns -->

<Table ss:ExpandedColumnCount="100" ss:ExpandedRowCount="66625" x:FullColumns="1" x:FullRows="1">

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="96"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="57"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="31.5"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="74.25"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="96.75"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="78.75"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="65.25"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="75"/>

<Column ss:AutoFitWidth="0" ss:StyleID="s62" ss:Width="83.25"/>

<Column ss:StyleID="s62" ss:Width="48.75"/>

<Column ss:AutoFitWidth="0" ss:Width="49.5"/>

<Column ss:AutoFitWidth="0" ss:Width="73.5"/>

<Column ss:Width="60.75"/>

<Column ss:Width="43.5"/>

<Column ss:Width="48.75"/>

<Column ss:AutoFitWidth="0" ss:Width="82.5"/>

<Column ss:AutoFitWidth="0" ss:Width="68.25"/>

<Column ss:AutoFitWidth="0" ss:Width="82.5"/>

<!--SAPYard Tip-->

<!--* Now your first Row is getting printed with two columns -->

<Row>

<!--SAPYard Tip-->

<!--* Check here, you are setting the style defined above -->

<!--* This is cell/column 1 of row 1-->

<Cell ss:StyleID="s63">

<!--SAPYard Tip-->

<!--* Check this is hard coding of Data -->

<Data ss:Type="String">Report source</Data>

</Cell>

<!--* Check here, you are setting another style defined above -->

<!--* This is cell/column 1 of row 1-->

<Cell ss:MergeAcross="3" ss:StyleID="m31454080">

<Data ss:Type="String">

<!--* Check here value from variable is getting printed -->

<tt:value ref="VARIABLES"/>

</Data>

</Cell>

</Row>

<!--SAPYard Tip-->

<!--* Now your second Row is getting printed -->

<Row>

<Cell ss:StyleID="s63">

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

</Cell>

<Cell ss:MergeAcross="3" ss:StyleID="m31454100">

<Data ss:Type="String">

<tt:value ref="WORKAREAS"/>

</Data>

</Cell>

</Row>

<!--SAPYard Tip-->

<!--* Now your third Row is getting printed and so on -->

<Row>

<Cell ss:StyleID="s63">

<Data ss:Type="String">Date Selection On</Data>

</Cell>

<Cell ss:MergeAcross="3" ss:StyleID="m31454120">

<Data ss:Type="String">

<tt:value ref="VARIABLES"/>

</Data>

</Cell>

</Row>

<Row>

<Cell ss:StyleID="s63">

<Data ss:Type="String">Date Worked From</Data>

</Cell>

<Cell ss:MergeAcross="3" ss:StyleID="m31454140">

<Data ss:Type="String">

<tt:value ref="VARIABLES"/>

</Data>

</Cell>

</Row>

<Row>

<Cell ss:StyleID="s63">

<Data ss:Type="String">Date Worked To</Data>

</Cell>

<Cell ss:MergeAcross="3" ss:StyleID="m31454160">

<Data ss:Type="String">

<tt:value ref="WORKAREAS"/>

</Data>

</Cell>

</Row>

<!--SAPYard Tip-->

<!--* Add all your extra rows here onwards -->

<!--SAPYard Tip-->

<!--* Check here, multiple columns/cell for one row is printed -->

<!--These are like headers of a table for my internal table-->

<!--* Check here, the row would start from number 12. Change as per your requirement -->

<Row ss:Index="12">

<Cell ss:StyleID="s97">

<Data ss:Type="String">Work Order</Data>

</Cell>

<Cell ss:StyleID="s97">

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

</Cell>

<Cell ss:StyleID="s97">

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

</Cell>

<Cell ss:StyleID="s97">

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

</Cell>

<Cell ss:StyleID="s97">

<Data ss:Type="String">Notification No (IR)</Data>

</Cell>

<!--SAPYard Tip-->

<!--* Above row ended here -->

</Row>

<!--SAPYard Tip-->

<!--* Here data is being loop in an internal table. Just like normal LOOP -->

<tt:loop ref=".table">

<Row>

<Cell>

<Data ss:Type="String">

<!--SAPYard Tip-->

<!--* This is the field of the table and first column in the excel -->

<!--* Value in field WORKORDER for table TABLE would be printed here-->

<tt:value ref="WORKORDER"/>

</Data>

</Cell>

<Cell>

<Data ss:Type="String">

<!--SAPYard Tip-->

<!--* This is the field of the table and second column in the excel -->

<!--* Value in field OPERATION for table TABLE would be printed here-->

<tt:value ref="OPERATION"/>

</Data>

</Cell>

<Cell>

<Data ss:Type="String">

<!--SAPYard Tip-->

<!--* This is the field of the table and third column in the excel -->

<!--* Value in field PLANT for table TABLE would be printed here and so on-->

<tt:value ref="PLANT"/>

</Data>

</Cell>

<!--SAPYard Tip-->

<!--* Add all your extra columns/cell here onwards -->

</Row>

<!--SAPYard Tip-->

<!--* Loop ends here -->

</tt:loop

</Table>

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<Selected/>

<Panes>

<Pane>

<Number>3</Number>

<ActiveRow>4</ActiveRow

<ActiveCol>12</ActiveCol

</Pane>

</Panes>

<ProtectObjects>False</ProtectObjects

<ProtectScenarios>False</ProtectScenarios

</WorksheetOptions

</Worksheet>

<Worksheet ss:Name="Sheet2">

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<ProtectObjects>False</ProtectObjects

<ProtectScenarios>False</ProtectScenarios

</WorksheetOptions

</Worksheet>

<Worksheet ss:Name="Sheet3">

<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">

<ProtectObjects>False</ProtectObjects

<ProtectScenarios>False</ProtectScenarios

</WorksheetOptions

</Worksheet>

</Workbook>

</tt:template

</tt:transform