I'd like to set the background color for some tags. Neither CSS background-color or attribute bgcolor seems to work.
Is there a mso- CSS that will give me background color?
Perl, XSL only, No Microsoft products. It should work for OS X and Windows, with current versions of Excel.
xml: <d>Y</d>
html: <td class="Status Y" bgcolor="yellow">Y</td>
css: .Status.Y { background-color: yellow; }
if anyone cares , the full xsl is
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="html"
encoding="UTF-8"
indent="yes"
omit-xml-declaration="yes"
/>
<xsl:template match="project">
<html>
<head>
<title>
<xsl:text>pqs - </xsl:text>
<xsl:value-of select="table[@id='Head']/caption/row[1]/d[1]"/>
</title>
<style type="text/css">
table,th,td {
border-width: thin;
border-style: outset;
border-color: gray;
border-collapse: collapse;
background-color: white;
mso-width-source:auto;
}
th,td {
padding: 0 1em 0 1em;
border-style: inset;
}
.Status { text-align: center; }
.Status.G { background-color: #0F0; }
.Status.R { background-color: red; }
.Status.Y { background-color: yellow; }
.Status.I { background-color: #6F00FF; }
</style>
</head>
<body>
<xsl:apply-templates select="node()"/>
</body>
</html>
</xsl:template>
<xsl:template match="table|caption">
<xsl:if test="@id">
<h1><xsl:value-of select="@id"/></h1>
</xsl:if>
<xsl:apply-templates select="caption"/>
<xsl:if test="count(row)>0" >
<table id="{@id}" class="{local-name(.)}">
<xsl:apply-templates select="row"/>
</table>
</xsl:if>
</xsl:template>
<xsl:template match="row">
<tr><xsl:apply-templates select="node()"/></tr>
</xsl:template>
<xsl:template match="h">
<th><xsl:value-of select="@name"/></th>
</xsl:template>
<xsl:template match="d">
<td>
<xsl:variable name="text" select="text()"/>
<xsl:variable name="p" select="position()"/>
<xsl:variable name="class" select="../../row[1]/h[$p]/@name"/>
<xsl:choose>
<xsl:when test="$class='Status'">
<xsl:attribute name="class">
<xsl:value-of select="concat($class,' ',$text)"/>
</xsl:attribute>
<xsl:attribute name="bgcolor">
<xsl:choose>
<xsl:when test="$text='G'"><xsl:value-of select="'green'"/></xsl:when>
<xsl:when test="$text='R'"><xsl:value-of select="'red'"/></xsl:when>
<xsl:when test="$text='Y'"><xsl:value-of select="'yellow'"/></xsl:when>
<xsl:when test="$text='I'"><xsl:value-of select="'#6F00FF'"/></xsl:when>
<xsl:otherwise><xsl:value-of select="white"/></xsl:otherwise>
</xsl:choose>
</xsl:attribute>
</xsl:when>
</xsl:choose>
<xsl:value-of select="text()"/>
</td>
</xsl:template>
</xsl:stylesheet>