excel output (different sheets)

[Former Member]

hi all,

i need to output srm data to an excel file through xi. header items should be separated from the line items. header items will be in one sheet while the line items will be shown in another sheet but in the same excel file. Is this possible?

Thanks all!

[jyothi_anagani · Accepted solution]

Hi,

Develope an Adapter Module To Write into an excel sheet.

And use That Module in Receiver File Adapter.

Use The code Suggested By Fariha Ali in the Adapter Module Development.

Use The below link to Develop an Adapter Module.

http://wiki.sdn.sap.com/wiki/display/ABAP/AdapterModuleToReadExcelFilewithMultipleRowsandMultiple+Columns

Thanks.

Edited by: Jyothi Anagani on Jan 25, 2010 10:02 AM

[former_member190389]

See this WIKI by Shabarish

http://wiki.sdn.sap.com/wiki/display/XI/CODE-CreateanExcelFileviatheJExcel+API

Create one more sheet

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

Edited by: Fariha Ali on Jan 25, 2010 2:16 PM