Reading mail attachment, which is excel file with xHTML content

[Former Member]

Hello

Mail is sent from Ariba which has ZIP attachment. Inside that zip file is a '.xls' file. But this '.xls' file has xHTML content (i.e content is wrapped around xHTML tags).

Purpose is to read the attachment , convert it in csv /.doc format and send it to R/3.

Till now, PI is able to read mail , unzip the attachment, but not able to convert the .xls file into desired format in PI.

Size of File>50000 records;

Kindly suggest.

Thanks

Pratibha

Attaching the sample excel file with xHTML properties;

[Former Member]

Hi Pratibha

Try to write a java mapping which do the following

1. Unzip the payload received from mail adapter.

2, Read the excel file ( there are some api available for that. one of them is JXL )

3. Populate the csv file

Your sample file is missing in the thread. please provide the sample file again.

[Former Member]

Hi Indrajit

Thanks for your reply.

Yes we have been working on java code, but till now no luck.

Mail adapter is able to pull the mail and unzip the attachment using the std adapter modules, but we could do conversion of xHTML contents of excel file into any understandable format (csv,doc,txt).

Any help in java code shall also be appreciated.

Thanks