cancel
Showing results for 
Search instead for 
Did you mean: 

I have a scenario. Import IDOC into PI and PI transform IDOC to Excel. Using mail adapter attach that Excel using pi and send to customer. Can you please help me on the same?

Former Member
0 Kudos

HI Experts,

I have a scenario. Import IDOC into PI and PI transform IDOC to Excel. Using mail adapter attach that Excel using pi and send to vendor. Can you please help me on the same?

Thanks

SaiSreevastav

Accepted Solutions (0)

Answers (1)

Answers (1)

Harish
Active Contributor
0 Kudos

Hi Sai,

you can use XSLT or java mapping or adapter module to convert IDOC xml to XLS. Please refer the below blog

then after converting to Excel, you can use the payloadswap bean in mail adapter

regards,

Harish

Former Member
0 Kudos

HI Harish,

  Thanks for the reply. Excel contains Images and data should be in order like

Image

name

sdfgsd

orland123

address

dfhsfdgth

fghfg334

Belgium

information mis

aSDfsdgjdhflkfsgklhfg

I need IDOC data should ne in above order including images. Your help is appreciated.

Thanks

SAI