Skip to Content
0
Former Member
Apr 05, 2011 at 10:03 AM

Graphical Mapping to a Simple xls file

24 Views

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"?>

urn://hmel.com/SAPERP">

<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>