PI to genrate excel sheet as output

[Former Member]

Hello All,

Interface is outbound. The mode of communicaiton from SAP ECC to SAP PI is through Proxy XML. And from SAP PI to Target application the mode of communication is Excel sheet. PI has to generate Excel sheet to the target system read.PI version using is 7.1

Can you please help in getting solution for this requirement

Thanks,

Regards,

Moorthy

[Former Member]

Hi Naresh,

For your requirement the best way is JAVA Mapping check below thread for code snippet

Thanks,

Krupa

[Former Member]

Hi Naresh

The easiest way would be to write a java mapping using JXL api to generate the excel sheet.

Check this for sample code

Excel and Java - Read and Write Excel with Java - Tutorial

[former_member184720]

Hi Naresh - Did you check the below blogs?