xml to excel conversion

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.


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.


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%