Click here to Skip to main content
15,903,012 members
Articles / Web Development / ASP.NET

XSLT to transform Excel XML spreadsheet to CSV or HTML table

Rate me:
Please Sign up or sign in to vote.
3.72/5 (15 votes)
15 Jul 2003 171.2K   1.8K   36   12
XSLT to transform Excel XML spreadsheet to CSV or HTML table.


One day, I needed to create a conversion of MS Excel saved XML spreadsheet to CSV file. I believe the MS Office Web Component (OWC) ver. 10 spreadsheet component can also expose XML data.

Practical use

Here is an example web page showing how to use OWC spreadsheet with it.

The Script

<script language="JavaScript">

    function action()
        //get the xmldata
        var strXML = Spreadsheet1.XMLData
        // create xml object
        var xml = new ActiveXObject("Microsoft.XMLDOM")
        xml.async = false

        // Load XSL
        var xsl = new ActiveXObject("Microsoft.XMLDOM")
        xsl.async = false

        // Transform
        form1.csvValue.value = xml.transformNode(xsl)
        // csv submit to backend 
        // alert(form1.xmlValue.value) 


The Body

  <h3> Payroll Input Form </h3>
   <OBJECT id="Spreadsheet1" style="WIDTH: 100%; HEIGHT: 80%" 
           classid="clsid:0002E551-0000-0000-C000-000000000046" >
    <PARAM NAME="xmlURL" VALUE="book_no_xsl.xml">
  <form id="form1" method="post" runat="server">
    <input type="button" onclick="action()">
   <input id="csvValue" type="hidden" name="csvValue">

How to Use it

Simply unzip and look at book.xml.


Here is a piece of code I use to transform Excel XML to CSV.

'Create a new XslTransform object.
Dim xslt As New XslTransform
'Load the stylesheet.
xslt.Load(Server.MapPath(".") & "excel2csv.xsl")

Dim doc As New XmlDocument
'xmldata is string, use doc.Load(fileName) for file.

'Create an XmlTextWriter which outputs to a file.
Dim fileName As String
fileName = Server.MapPath(".") & "book.csv"

Dim writer As XmlWriter = New XmlTextWriter(fileName, Nothing)
'Transform the data and send the output to the console.

xslt.Transform(doc, Nothing, writer, Nothing)


-- May the code be with you.


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By
Web Developer
United States United States
Frank is a Sr. UI Software Engineer specialized in MFC and Business Applications.

He has worked in BROADBASE, KANA, Macromeda and Siebel Systems.

Comments and Discussions

NewsVariation: Reformatting Excel XML to "usable" XML with proper element names. Pin
Anamera2-Jun-14 3:22
Anamera2-Jun-14 3:22 
GeneralTransformation Not Always Correct Pin
CyberKnet28-Mar-05 6:45
CyberKnet28-Mar-05 6:45 
Generalxml to csv Pin
pnunez15-Dec-03 5:51
pnunez15-Dec-03 5:51 
GeneralNot a lot of credibility Pin
Dirk Vandenheuvel16-Jul-03 22:55
Dirk Vandenheuvel16-Jul-03 22:55 
GeneralRe: Not a lot of credibility Pin
John M. Drescher17-Jul-03 3:38
John M. Drescher17-Jul-03 3:38 
GeneralRe: Not a lot of credibility Pin
folderMonkey17-Jul-03 6:13
folderMonkey17-Jul-03 6:13 
GeneralRe: Not a lot of credibility Pin
jemodurn17-Jul-03 6:30
jemodurn17-Jul-03 6:30 
GeneralRe: Not a lot of credibility Pin
John M. Drescher17-Jul-03 10:54
John M. Drescher17-Jul-03 10:54 
GeneralRe: Not a lot of credibility Pin
zakriah12-Mar-07 8:39
zakriah12-Mar-07 8:39 
QuestionCan not download the source zip file Pin
User 4002516-Jul-03 8:26
User 4002516-Jul-03 8:26 
AnswerRe: Can not download the source zip file Pin
jemodurn16-Jul-03 15:33
jemodurn16-Jul-03 15:33 
GeneralCannot download Pin
Jesterka9-Jul-03 23:32
Jesterka9-Jul-03 23:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.