IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  xml to excel conversion

    Posted 10/10/12 05:22 AM

    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


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: xml to excel conversion

    Posted 10/25/12 06:43 AM

    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%


    #webMethods
    #Integration-Server-and-ESB