Mail Sender adapter to process excel file attachment

[PallaviU]

Hi Experts,

I am developing a scenario where input is Excel file attachment from mail and need to process through RFC. I have used Pay Load Swap Bean for swapping the attachments and Module Transform Bean to convert the Excel file to XML. Does Module Transform Bean converts from Excel to XML?

If so what are the parameters that need to be passed? What will I specify for field Separator?

Can any one suggest on this please?

Thanks in Advance

Pallavi

[vicky20691]

Hi Pallavi,

No standard module to convert excel to xml.

you can have 2 options in sender channel

Option 1

1. PayloadSwapBean

2. Custom Module to convert excel to XML

Option 2

1. PayloadSwapBean

then call java mapping which will convert excel to xml

XLS to XML conversion using JAVA Mapping in SAP XI 7.0 - Netweaver Technology - SCN Wiki

[manoj_khavatkopp]

Pallavi,

MTB cant convert Excel to XML .

You  need to use Custom module  : or handle via java-mapping.

Br,

Manoj