HTML Email with Excel Attachment

[Krishneel]

Hey Folks,

We have a PI 7.4 AEX Java Only System where I need to create the following interface:

- ECC creates a flat file which PI picks up. From this file PI needs to generate an HTML email with an EXCEL attachment (both .xls and .xlsx need to be supported).

Is this possible in PI? Can anyone point me in the right direction?

Thanks,

Krishneel

[praveen_sutra]

Hi,

As Baskar said you can very well use java mapping to create the attachment.

http://poi.apache.org/

http://scn.sap.com/community/pi-and-soa-middleware/blog/2009/04/05/excel-files--how-to-handle-them-i...

please go through above mentioned links for getting help to write the code.

thanks and regards,

Praveen T

[baskar_gopalakrishnan2]

There is no standard way to generate excel in PI.  You can use mail adapter and the content of the mail can be coded using html syntax codes such as html tag, body tage etc  in the string format. You need to use custom module or java mapping to create excel document. You can use JEXCEL API to create excel document and attach it in the mail receiver adapter.