XML to XLS file converting in sap cpi using standard or groovy

[former_member229127]

HI All,

Can you help to convert the xml to xls file which i need to post in the sftp in sap cpi.

Regards,

Sandhya

[Sriprasadsbhat]

Hello Sandhya,

Please refer below blog and you need to use Apache POI libraries to generate XLS.

https://blogs.sap.com/2020/10/06/converting-xls-file-to-xml-format-with-cpi-groovy-script/

https://howtodoinjava.com/java/library/readingwriting-excel-files-in-java-poi-tutorial/

Regards,

Sriprasad Shivaram Bhat

[former_member229127]

Hi sriprasadshivaramabhat ,

The blog which you have provided is XLS to XML but i need xml file to XLS that in groovy do you have any code for it?

Regards,
Sandhya

[maik_bosch]

sandhya.ravi see https://blogs.sap.com/2018/09/04/formatconversionbean-arrives-in-cpi/ and more discussion regarding this in https://answers.sap.com/questions/13279498/generate-output-file-with-xls-or-xlsx.html