Graphical Mapping to a Simple xls file

[Former Member]

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

<ns0:HRShiftMasterData xmlns:ns0="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"?>

<!-- edited with XMLSpy v2011 sp1 (http://www.altova.com) by a (a) -->

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

[Former Member]

I think in this case, is better to use a JavaMapping or an AbapMapping...

In Graphical Mapping maybe, the only way is to map constant value for field like <CELL DATA TYPE>, and min occurs 3... but imho it isn't a nice solution.

[Former Member]

Let me try this out

any other thoughts on this mapping???

[Former Member]

Was able to do this by duplicating the <CELL> entries...

Thanks

[Former Member]

Check out this link:

http://sapxitutorials.blogspot.com/2010/07/create-fancy-excel-files-with-sap-pi.html

Maybe, can be helpfull for you!

[Former Member]

And also this blog:

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

This is an old sdn forum 3d:

[Former Member]

Hi,

I have seen those. thanks!!

Please assist me in the mapping.