XLS to CSV scenario in SAP PI/PO

[former_member355445]

HI All ,

i have a requirement that i need to read the xls file and convert the same in to xls file using sftp adapter. with mapping or with out mapping is okay for me.

can you please help me on this.

the xls has 5 columns which means 5 fields and under these columns we have values.

thanks,

Viany.

[former_member182412]

Hi Vinay,

• If you want to read the excel file then you need to use below custom module to convert to XML.

• After that you can use FCC in receiver channel to convert from XML to CSV.

Regards,

Praveen.

[former_member355445]

HI Praveen,

do we have this feature in the message transfer bean , because we do not have excel transform bean.

Thanks,

Vinay.

[former_member182412]

Hi Vinay,

You need to deploy the EAR file into your system before using it in the channel. Check SourceCode section of the blog.

Regards,

Praveen.