xml to excel conversion

,
1

Hi Experts,

There is an xml input and that is not in the defined structure every time. The structure of xml will change every time. The requirement is to change the in-coming xml to a excel format. Any ideas…?

In the similar way I need the result in pdf aswell.

Thanks.

Note: If you try to open any xml directly in MS-Excel application, it will show the values available in the xml in the excel cells, I need the same behavior without the pop-up.

Regards,
Suresh.A

2

Use XSLT
runStringTemplateOnPipe service

<?xml version="1.0" encoding="UTF-8"?>













































Id Name Role Location Project

%loop Group%


%value Id%


%value Name%


%value Role%


%value Project%


%value Location%


%end%