Script Output:
First Name Last Name Sales
Andrew Fuller 5000
Janet Leverling 6250
Steven Buchanan 3245
Margaret Peacock 4685
Robert King 5290
David Andersen 6420
Frank Edwards 3840
Kate Richards 4260
Edward Jones 3450
Laura Callahan 3675
Greg Miller 5640
Tammy Steel 3570

By now I'm sure you're probably using XML files for something. Whether it be data transfer, storage, caching, or something else altogether, it's a great technology. Anyway, my point is that you've probably got a few XML files lying around your website. While XML is designed to be human readable as much as it is machine readable, sometimes it's nice to look at something without the <>'s.

This little script will take an XML file and an XSL file and combine them to produce whatever output you want. The sample files (xmlxsl.xml and xmlxsl.xsl) contain a copy of some of our fake sample data and convert it to a basic HTML table, but you can use the same code to transform your data into whatever you want... just change the stylesheet.
Using Remote XML/XSL Files

If you're going to be pulling either the XML of XSL file from a remote server, you should take a look at the remote version of this sample: XML to HTML (via XSL) - Remote Files.
Update: Common Functions for Working with XML and XSL Files

One of our readers read our sample and decided to share a few functions that he's been using to handle his XML and XSL needs. Here's his email:

I've just looked at XML to HTML (via XSL) Classic ASP Sample, and I realised that I've written a few (5) functions for doing this, but with a few enhancements

1. You can do everything in one function call
2. The more complicated functions call the simpler ones, keeping everything clean
3. You can pass parameters into your stylesheet straight from the function call

The functions are:

* GetXslStyleSheet(ByVal strStyleSheetLocation)
* GetXslStyleSheetWithParams(ByVal strStylesheetLocation, ByVal strParams)
* GetXmlDocument(ByVal strDocumentLocation)
* GetXmlDocumentByStyleSheet(ByVal strDocumentLocation, ByVal strStyleSheetLocation)
* GetXmlDocumentByStyleSheetWithParams(ByVal strDocumentLocation, ByVal strStyleSheetLocation, ByVal strParams)

Here is the pure file (complete with pseudo XML comments) - I'll write up a little guide to the code if you like it. It's not doing anything special, but I don't think I've noticed anything quite like it being posted before.

Thanks
Chris Surfleet

No Chris... Thank You! I sure many of our users will find the functions extremely helpful. Oh and speaking of the functions, here they are: server-xml.zip (1 KB). Like Chris said, they're pretty simple to figure out and there are basic comments included with the source. Thanks again Chris.