RishadanPort
asked on
Transforming XML to Excel Worksheets
I have an XML file that is a series of Job nodes:
<Job>
... data
</Job>
<Job>
... data
</Job>
...
Currently, we have a XSLT stylesheet that converts this XML file, to a HTML view, what we need now is a way to convert the XML data to a Excel style sheet that the data can be analyzed. What we need is that each
Job node be put on a seperate worksheet in excel.
What is a good approach to use for doing this? Any help would be useful
<Job>
... data
</Job>
<Job>
... data
</Job>
...
Currently, we have a XSLT stylesheet that converts this XML file, to a HTML view, what we need now is a way to convert the XML data to a Excel style sheet that the data can be analyzed. What we need is that each
Job node be put on a seperate worksheet in excel.
What is a good approach to use for doing this? Any help would be useful
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.