Read multi-tabbed excel file attachments from Sender Mail Adapter.

[Former Member]

There is a need to read excel attachments from incoming email to a

mailbox. We know we can use Sender Mail adapter to easily read .xml, .txt

or .csv attachments.

For excel attachments we know from SDN that you have to write

adapter modules to handle excel. However the excel file we need to read has

multiple worksheets(tabs) and data may be contained in any of them.

Is it possible to use SAP XI Mailsender adapter to read such a file as an attachment? What kind of module development would we need for this? I am not much of a Java programmer so examples or links to other documentation would help.

Thanks,

Rudra

[baskar_gopalakrishnan2 · Accepted solution]

Rudra,

Use Java Mapping. There is a free java api available called JExcelAPI to achieve this.

Shabarish's blog describes about this. This might be helpful to you

/people/shabarish.vijayakumar/blog/2009/04/05/excel-files--how-to-handle-them-in-sap-xipi-the-alternatives