Excel(.xlsx) to .csv or .xml conversion be done Using UDF Java Mapping or Graphical Mapping?

[Former Member]

Hi All,

The requirement is FTP to FTP wherein the source structure is Excel .XLSX or .XLS format and target structure is .CSV/.XML format.

Please help me with the conversion in PI7.0 using JAVA MAPPing/UDF code or Graphical Mapping or at communication channel level under Module Tab.

Many Thanks.....!!

[Harish]

Hi Rajesh,

Please check the below blogs

Also please close your previous threat.you already raised the same question in that, it would be good to provide that threat link here.

Excel(.xlsx) to .csv converison in SAP PI XI | SCN

[Former Member]

Hi Harish,

I tried below link but facing error:

PI/XI: Reading MS Excel's XLSX and XLSM files with standard PI modules - easily...

Excel Files - How to handle them in SAP XI/PI (The Alternatives)

I have implemented Michal solution blog getting below error in SXMB_MONI- .

MAPPING DURING EXECUTE ERROR

https://scn.sap.com/message/16075007