• 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:

   ... data
   ... data

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


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

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

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