IDOC to spreadsheet

[Former Member]

Hi,

Please go through following requirement.

Scenario : Idoc to csv/spreadsheet.

The spreadsheet will have 2 tabs, first will be containing configuration info and the 2nd will contain data.

Can you please help me with the ways it can be implemented.

I am able to produce 2 different files but unable to generate single spreadsheet with 2 tabs.

Regards,

Vishal K

[sunilchandra007 · Accepted solution]

Hi Vishal,

If you are going for idoc to csv, it wont help directly as csv doesn't allow to have multiple sheets. For idoc to spreedsheet having multiple sheets, there are basically 3 ways :

1. Java Mapping or Adapter module - For help, you can check this [wiki|http://wiki.sdn.sap.com/wiki/display/XI/CODE%20-%20Create%20an%20Excel%20File%20via%20the%20JExcel%20API?bc=true]

WritableSheet sheet = workbook.createSheet("Page1", 0);

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

<Worksheet ss:Name="Arkusz1">

3. Conversion agent - /people/alexander.ong/blog/2009/03/30/how-to-handle-excel-documents-with-sap-pi

Regards,

Sunil Chandra