Convert XML in to .xlsx File

[manigram]

Hi,

I have to create .xlsx by using SFTP adapter, please suggest me how to achieve  this. What delimiter i have to use.

Regards,

manigandan

[naveen_chichili]

Hi Mani,

DId you get a chance to look at the below blog..

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

Regards,

Naveen    

[manigram]

HI,

I have done XSL mapping to convert xml to excel, but the problem as per requirement is file extension i given .xslx. am unable to open this file it's saying file is incorrect or corrupt.

I found some blog with microsoft, by default xslx file is an archived file.

Please share your input on this.

Regards,

Manigandan 

[Former Member]

Hi,

There are few threads existing on this topic.

Please refer before posting new queries.

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

Here is a blog on this same topic,

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

Thanks,

Karthik

[iaki_vila]

Hi Maningandan

Check this Aashish Sinha blog and subsequents

With java mapping:

Regards.