Process .xls file?


#1

I have found how to write a php script to process xslt and xml to produce a page.

Is there a better way? Specifically, DreamWeaver suggests having a .xls file with some boilerplate to get automatic xslt processing. Is this available on DreamHost? The boilerplate is:

<?xml version="1.0" encoding="utf-8"?><!-- DWXMLSource="puzdata.xml" --><!DOCTYPE xsl:stylesheet  [
	<!ENTITY nbsp   " ">
	<!ENTITY copy   "©">
	<!ENTITY reg    "®">
	<!ENTITY trade  "™">
	<!ENTITY mdash  "—">
	<!ENTITY ldquo  "“">
	<!ENTITY rdquo  "”"> 
	<!ENTITY pound  "£">
	<!ENTITY yen    "¥">
	<!ENTITY euro   "€">
]>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<xsl:output method="html" encoding="utf-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:template match="/">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Simple XSLT Example</title>
</head>

<body>
<!--  body patterns/output goes here  -->

</body>
</html>

</xsl:template>
</xsl:stylesheet>

#2

DreamWeaver’s approach (XSLT in the browser) will not work in all web browsers, and isn’t particularly search-engine friendly. I’d avoid it.


#3

DreamWeaver describes both server-side and client-side XSLT. They do mention that the client-side approach fails on older browsers. The code in the original query is DreamWeaver’s server-side version.