Transforming XML to Excel Worksheets

Posted on 2008-11-06
Last Modified: 2008-11-06
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
Question by:RishadanPort
    1 Comment
    LVL 6

    Accepted Solution

    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

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    In this tutorial I will aim to show you how simple is making a small application in WhizBase, how to add, remove and update data in the DB. I will make a small address book application where you can add, browse, update and remove addresses. I wi…
    Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
    Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now