cancel
Showing results for 
Search instead for 
Did you mean: 

Mail adapter read excel file

former_member194677
Participant
0 Kudos

Hi Experts,

I have requirement to read a excel file from Mail. in my scenario excel file name will be different every time. My question is can we handle this using *.xls in Module configuration(swap.keyvalue).

Please suggest your valueable inputs and let me know if there is any other option to handle this.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

do you want to read the excel content ?

if so you can use the same as described in my article:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/12/06/pixi-reading-ms-excels-xlsx-and-x...

for payloadswapbean have a look at my old article:

http://scn.sap.com/people/michal.krawczyk2/blog/2005/12/18/xi-sender-mail-adapter--payloadswapbean--...

Regards,

Michal Krawczyk

former_member194677
Participant
0 Kudos

Hi Michal,

Thanks for the response.

Yes i want to read the content of excel.

Thanks

Former Member
0 Kudos

Hi,

Use content-description to swap the attachemnt with main document.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/bf37423cf7ab04e10000000a1550b0/content.htm

swap.keyName -> content-description

swap.keyValue -> MailAttachment-1

Thanks

Amit Srivastava

former_member194677
Participant
0 Kudos

Hi Amit,

the mail will come with 2 attachments. Xls and pdf. i have to pick excel. every time the name of excel file will be changed. MailAttachment-1 will resolve the issue to read the file with different names?

Thanks

santosh

Former Member
0 Kudos

Hi,

If ur xls file is first attachment then it will work..please try the same.

Thanks

Amit Srivastava