Hi,
I have to generate an .xls file. For this I am using the excel xml format as the target message in mapping.
I need some help in mapping my source to target.
please help
The SOURCE xml is:
<?xml version="1.0" encoding="UTF-8"?>
<HRShiftMasterRow>
<PAYCODE>10000001</PAYCODE>
<DAY_1>a</DAY_1>
<DAY_2>b</DAY_2>
</HRShiftMasterRow>
<HRShiftMasterRow>
<PAYCODE>10000002</PAYCODE>
<DAY_1>p</DAY_1>
<DAY_2>q</DAY_2>
</HRShiftMasterRow>
</ns0:HRShiftMasterData>
The TARGET MESSAGE as:
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook>
<Worksheet ss:Name="Sheet1">
<Table>
<Row>
<Cell>
<Data ss:Type="Number">10000001</Data>
</Cell>
<Cell>
<Data ss:Type="String">a</Data>
</Cell>
<Cell>
<Data ss:Type="String">b</Data>
</Cell>
</Row>
<Row>
<Cell>
<Data ss:Type="Number">10000002</Data>
</Cell>
<Cell>
<Data ss:Type="String">p</Data>
</Cell>
<Cell>
<Data ss:Type="String">q</Data>
</Cell>
</Row>
</Table>
</Worksheet>
</Workbook>