Convert XLSX file in XML and vice versa in SAP PI 7.1

[former_member196519]

Hi,

I am using SAP PI 7.1 SP 14. I have some query regarding converting XLSX file in to XML and vice versa.

1.      Can we convert XLSX in to XML through Standard Adapter modules or we have to write any customized code for this?

2.      Can it be used for file or FTP adapter in PI 7.1 or not?

3.      Can we have any blog for outbound scenario for XML to XLSX?

Thanks in advance and appreciate your response <removed by Moderator>.

Kumar

Message was edited by: Prateek Raj Srivastava

[nabendu_sen · Accepted solution]

Hi Kumar,

Check the below blog of Michal.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/12/06/pixi-reading-ms-excels-xlsx-and-x...

The above blog answers your question 1 & 3, for Question 2 - Answer Yes.

[former_member196519 · Accepted solution]

Hi Nabendu,

I have gone through this Blog but I want to confirm that the Adapter Module used in blog are standard or customized. I have query also if we can use this in file or FTP adapter in PI 7.1 or not?

Thanks,

Kumar

[former_member184789 · Accepted solution]

Hi Kumar,

The PayloadZipbean & Payloadswapbean in the above blog are standard beans:

http://help.sap.com/saphelp_nw04/helpdata/en/45/da9358a1772e97e10000000a155369/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/bf37423cf7ab04e10000000a1550b0/content.htm

Also in the blog, Michal says, "This method obviously does not only work with File adapter but can also be used with Mail adapter to read MS Excel's attachments or with any other Java based adapter that has the possibility to pass MS Excel files."

[nabendu_sen · Accepted solution]

Hi Kumar,

These are Standard Modules available with Technical Adapters with PI 7.1. You just need to include them in Adapter, Thats all!

[former_member196519 · Accepted solution]

Thanks Adarsh for your response!

I read that blog about file adapter. Thats what I wanted to make sure that it can be used for file or FTP both adapter in SAP PI 7.1 or not?

[former_member196519 · Accepted solution]

Hi Nabendu,

Thanks for your confirmation. Could you please share any blog or document for XML to XLSX.

Regards,

Kumar

[former_member184789 · Accepted solution]

Hi,

for xml to excel conversion, refer to:

http://scn.sap.com/message/8088732

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/16/convert-incoming-xml-to-excel-or-...

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/16/convert-incoming-xml-to-excel-she...

[former_member196519]

Hi,

Now I am able to solve this issue. File need to be placed directly on PI server with out SXDA_TOOLS.  This method is useful only for numeric xlsx sheet. for Integer sheet we have to write again adapter module.

Thank you so much for your help!

Regards,

Kumar

[former_member184789]

Here is the discussion thread for this requirement:

http://scn.sap.com/thread/3201499