• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

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
0
RishadanPort
Asked:
RishadanPort
1 Solution
 
RishadanPortAuthor Commented:
I found this useful link that describes how to do this process:

http://msdn.microsoft.com/en-us/library/aa662189(office.11).aspx

the XSL statement for creating a worksheet foreach Job would be this:

<xsl:for-each select="Portfolio/Job">
<Worksheet ss:Name="{Name}">
   ... code here ...
</Worksheet>
</xsl:for-each>
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now