XSLT转换为HTML并基于XML中的数据格式化HTML
我对XSLT / XML和HTML相当陌生。 我有一个XML文件,我目前使用XSLT在C#中将其转换为HTML。 XML文件只代表从数据库中的表中提取的数据。 我目前可以很容易地使用XSLT将XML文件转换为HTML,而不需要太多格式化。 打开HTML时看起来很普通。 我打算格式化HTML,即根据XML文档中的某些关键值更改字体,背景颜色,字体颜色等。
XML是使用C#代码每天生成的。 XML文件的内容完全依赖于当天执行C#代码时数据库中表的内容。
XML看起来像这样
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<defects>
<Defectid>56</Defectid>
<testid>111</testid>
<summary>Release of DIT </summary>
<DetectedDate>2011-09-21 </DetectedDate>
<priority>2-Give High Attention</priority>
<status>Ready to Test</status>
<project>Business Intelligence</project>
<assignedTo>peter</assignedTo>
<detectedBy>john</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>829</Defectid>
<testid>111</testid>
<summary> Data request</summary>
<DetectedDate>2012-01-12 </DetectedDate>
<priority>3-Normal Queue</priority>
<status>Open</status>
<project>web</project>
<assignedTo>tcm</assignedTo>
<detectedBy>john</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>728</Defectid>
<testid>999</testid>
<summary>Data request</summary>
<DetectedDate>2012-01-11</DetectedDate>
<priority>3-Normal Queue</priority>
<status>Fixed</status>
<project>Business Intelligence</project>
<assignedTo>chris</assignedTo>
<detectedBy>peter</detectedBy>
<severity>3-Average</severity>
</defects>
</NewDataSet>
我打算做的是从这个XML中生成表格格式的HTML表格,但HTML表格中的行的字体颜色应根据“testid”属性设置。 即对于HTML上的字体颜色,每个“testid”属性都应该是唯一的。 由于每个testid的行每天都会根据数据库表中的数据进行更改,因此我不确定如何使用XSLT实现这一点。
当前的XSLT看起来像这样..如你所见,我已经对字体颜色进行了硬编码。
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:template match="/">
<table BORDER="1" CELLPADDING="3" CELLSPACING="2" WIDTH="100">
<tr>
<td nowrap="nowrap" width = "70">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Defect ID</b>
</h1>
</td>
<td nowrap="nowrap" width = "70">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Test ID</b>
</h1>
</td>
<td nowrap="nowrap" width = "400">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Summary</b>
</h1>
</td>
<td nowrap="nowrap" width = "150">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Detected Date</b>
</h1>
</td>
<td width = "200">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Priority</b>
</h1>
</td>
<td width = "200">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Status</b>
</h1>
</td>
<td width = "200">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Project</b>
</h1>
</td>
<td nowrap="nowrap" width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Assigned To</b>
</h1>
</td>
<td nowrap="nowrap" width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Detected By</b>
</h1>
</td>
<td nowrap="nowrap" width = "80">
<h1 style="font-family:verdana ;font-size:60%;color:green">
<b>Severity</b>
</h1>
</td>
</tr>
<xsl:for-each select="//defects">
<tr>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="Defectid"></xsl:value-of>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="testid"/>
</h1>
</td>
<td width = "400">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="summary"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="DetectedDate"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="priority"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="status"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="project"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="assignedTo"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="detectedBy"/>
</h1>
</td>
<td width = "100">
<h1 style="font-family:verdana ;font-size:60%;color:blue">
<xsl:value-of select="severity"/>
</h1>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
有人知道或有人能指导我吗?
以下是一种解决方案,最多可以应用20种不同的颜色 - 为每行应用特定颜色的testid。
请注意,有多少不同的testid发生并不重要。 另外请注意,颜色编码对testid本身没有提及 - 但这正是您想要的方式:-)。
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet
version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:std="http://www.standardColors.com">
<xsl:output method="html"/>
<xsl:variable name="colors">
<color>#0000FF</color>
<color>#FF0000</color>
<color>#00FFFF</color>
<color>#FFFF00</color>
<color>#347C2C</color>
<color>#800080</color>
<color>#3B9C9C</color>
<color>#A52A2A</color>
<color>#3BB9FF</color>
<color>#FF00FF</color>
<color>#6698FF</color>
<color>#808000</color>
<color>#8D38C9</color>
<color>#ADD8E6</color>
<color>#F660AB</color>
<color>#F87217</color>
<color>#F9B7FF</color>
<color>#FFA500</color>
<color>#FFE87C</color>
<color>#8E35EF</color>
</xsl:variable>
<xsl:variable name="testIDs" select="distinct-values(//testid)"/>
<xsl:variable name="colorList">
<xsl:for-each select="$testIDs">
<xsl:variable name="pos" select="position() mod 20"/>
<xsl:copy-of select="$colors/color[$pos]"/>
</xsl:for-each>
</xsl:variable>
<xsl:template match="/">
<html>
<head>
<style>
th, td {
border: solid black 1px ;
padding: 3px;
border-spacing:2px;
border-collapse: collapse;
width: 100px;
}
th {
font-family:verdana;
font-size:60%;
color:green;
align:center;
white-space: nowrap;
}
<xsl:for-each select="$testIDs">
<xsl:variable name="pos" select="position()"/>
tr.testid<xsl:value-of select="."/> {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:<xsl:value-of select="$colorList/color[$pos]"/>;
align:center
}
</xsl:for-each>
</style>
</head>
<body>
<table>
<tr>
<xsl:for-each select="/NewDataSet/defects[1]/*">
<th>
<xsl:value-of select="name(.)"/>
</th>
</xsl:for-each>
</tr>
<xsl:apply-templates select="*"/>
</table>
</body>
</html>
</xsl:template>
<xsl:template match="/NewDataSet/defects">
<tr>
<xsl:attribute name="class">testid<xsl:value-of select="testid"/></xsl:attribute>
<xsl:for-each select="*">
<td>
<xsl:value-of select="."/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
</xsl:stylesheet>
我将它应用于下面的xml:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<defects>
<Defectid>56</Defectid>
<testid>111</testid>
<summary>Release of DIT </summary>
<DetectedDate>2011-09-21 </DetectedDate>
<priority>2-Give High Attention</priority>
<status>Ready to Test</status>
<project>Business Intelligence</project>
<assignedTo>peter</assignedTo>
<detectedBy>john</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>829</Defectid>
<testid>111</testid>
<summary> Data request</summary>
<DetectedDate>2012-01-12 </DetectedDate>
<priority>3-Normal Queue</priority>
<status>Open</status>
<project>web</project>
<assignedTo>tcm</assignedTo>
<detectedBy>john</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>728</Defectid>
<testid>999</testid>
<summary>Data request</summary>
<DetectedDate>2012-01-11</DetectedDate>
<priority>3-Normal Queue</priority>
<status>Fixed</status>
<project>Business Intelligence</project>
<assignedTo>chris</assignedTo>
<detectedBy>peter</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>728</Defectid>
<testid>321</testid>
<summary>Data request</summary>
<DetectedDate>2012-01-11</DetectedDate>
<priority>3-Normal Queue</priority>
<status>Fixed</status>
<project>Business Intelligence</project>
<assignedTo>chris</assignedTo>
<detectedBy>peter</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>728</Defectid>
<testid>457</testid>
<summary>Data request</summary>
<DetectedDate>2012-01-11</DetectedDate>
<priority>3-Normal Queue</priority>
<status>Fixed</status>
<project>Business Intelligence</project>
<assignedTo>chris</assignedTo>
<detectedBy>peter</detectedBy>
<severity>3-Average</severity>
</defects>
<defects>
<Defectid>728</Defectid>
<testid>202</testid>
<summary>Data request</summary>
<DetectedDate>2012-01-11</DetectedDate>
<priority>3-Normal Queue</priority>
<status>Fixed</status>
<project>Business Intelligence</project>
<assignedTo>chris</assignedTo>
<detectedBy>peter</detectedBy>
<severity>3-Average</severity>
</defects>
</NewDataSet>
结果得到了
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style>
th, td {
border: solid black 1px ;
padding: 3px;
border-spacing:2px;
border-collapse: collapse;
width: 100px;
}
th {
font-family:verdana;
font-size:60%;
color:green;
align:center;
white-space: nowrap;
}
tr.testid111 {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:#0000FF;
align:center
}
tr.testid999 {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:#FF0000;
align:center
}
tr.testid321 {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:#00FFFF;
align:center
}
tr.testid457 {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:#FFFF00;
align:center
}
tr.testid202 {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:#347C2C;
align:center
}
</style>
</head>
<body>
<table>
<tr>
<th>Defectid</th>
<th>testid</th>
<th>summary</th>
<th>DetectedDate</th>
<th>priority</th>
<th>status</th>
<th>project</th>
<th>assignedTo</th>
<th>detectedBy</th>
<th>severity</th>
</tr>
<tr class="testid111">
<td>56</td>
<td>111</td>
<td>Release of DIT </td>
<td>2011-09-21 </td>
<td>2-Give High Attention</td>
<td>Ready to Test</td>
<td>Business Intelligence</td>
<td>peter</td>
<td>john</td>
<td>3-Average</td>
</tr>
<tr class="testid111">
<td>829</td>
<td>111</td>
<td> Data request</td>
<td>2012-01-12 </td>
<td>3-Normal Queue</td>
<td>Open</td>
<td>web</td>
<td>tcm</td>
<td>john</td>
<td>3-Average</td>
</tr>
<tr class="testid999">
<td>728</td>
<td>999</td>
<td>Data request</td>
<td>2012-01-11</td>
<td>3-Normal Queue</td>
<td>Fixed</td>
<td>Business Intelligence</td>
<td>chris</td>
<td>peter</td>
<td>3-Average</td>
</tr>
<tr class="testid321">
<td>728</td>
<td>321</td>
<td>Data request</td>
<td>2012-01-11</td>
<td>3-Normal Queue</td>
<td>Fixed</td>
<td>Business Intelligence</td>
<td>chris</td>
<td>peter</td>
<td>3-Average</td>
</tr>
<tr class="testid457">
<td>728</td>
<td>457</td>
<td>Data request</td>
<td>2012-01-11</td>
<td>3-Normal Queue</td>
<td>Fixed</td>
<td>Business Intelligence</td>
<td>chris</td>
<td>peter</td>
<td>3-Average</td>
</tr>
<tr class="testid202">
<td>728</td>
<td>202</td>
<td>Data request</td>
<td>2012-01-11</td>
<td>3-Normal Queue</td>
<td>Fixed</td>
<td>Business Intelligence</td>
<td>chris</td>
<td>peter</td>
<td>3-Average</td>
</tr>
</table>
</body>
</html>
在浏览器中看起来如下所示:
使用键的ADDED变体
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:std="http://www.standardColors.com"
exclude-result-prefixes="std">
<xsl:output method="html"/>
<xsl:variable name="colors">
<color>#0000FF</color>
<color>#FF0000</color>
<color>#00FFFF</color>
<color>#FFFF00</color>
<color>#347C2C</color>
<color>#800080</color>
<color>#3B9C9C</color>
<color>#A52A2A</color>
<color>#3BB9FF</color>
<color>#FF00FF</color>
<color>#6698FF</color>
<color>#808000</color>
<color>#8D38C9</color>
<color>#ADD8E6</color>
<color>#F660AB</color>
<color>#F87217</color>
<color>#F9B7FF</color>
<color>#FFA500</color>
<color>#FFE87C</color>
<color>#8E35EF</color>
</xsl:variable>
<!--<xsl:variable name="testIDs" select="distinct-values(//testid)"/>-->
<xsl:key name="testidKey" match="testid" use="text()"/>
<xsl:variable name="colorList">
<xsl:for-each select="//testid">
<xsl:if test="generate-id() = generate-id(key('testidKey', text())[1])">
<xsl:variable name="pos" select="position() mod 20"/>
<color>
<xsl:attribute name="testid"><xsl:value-of select="."/></xsl:attribute>
<xsl:value-of select="$colors/color[$pos]"/>
</color>
</xsl:if>
</xsl:for-each>
</xsl:variable>
<xsl:template match="/">
<html>
<head>
<style>
th, td {
border: solid black 1px ;
padding: 3px;
border-spacing:2px;
border-collapse: collapse;
width: 100px;
}
th {
font-family:verdana;
font-size:60%;
color:green;
align:center;
white-space: nowrap;
}
<xsl:for-each select="$colorList/color">
tr.testid<xsl:value-of select="@testid"/> {
font-family:verdana;
font-size:60%;
font-weight:bold;
color:<xsl:value-of select="."/>;
align:center
}
</xsl:for-each>
</style>
</head>
<body>
<table>
<tr>
<xsl:for-each select="/NewDataSet/defects[1]/*">
<th>
<xsl:value-of select="name(.)"/>
</th>
</xsl:for-each>
</tr>
<xsl:apply-templates select="*"/>
</table>
</body>
</html>
</xsl:template>
<xsl:template match="/NewDataSet/defects">
<tr>
<xsl:attribute name="class">testid<xsl:value-of select="testid"/></xsl:attribute>
<xsl:for-each select="*">
<td>
<xsl:value-of select="."/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
</xsl:stylesheet>
防止MSXML错误(以及任何其他使用的xsl引擎)
有关更多详细信息,请参阅将RTF转换为节点集,并将RTF转换为节点集通用方法。
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:std="http://www.standardColors.com"
xmlns:exslt="http://www.exslt.org/common"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
exclude-result-prefixes="std">
<xsl:output method="html"/>
<std:colors>
<color>#0000FF</color>
<color>#FF0000</color>
<color>#00FFFF</color>
<color>#FFFF00</color>
<color>#347C2C</color>
<color>#800080</color>
<color>#3B9C9C</color>
<color>#A52A2A</color>
<color>#3BB9FF</color>
<color>#FF00FF</color>
<color>#6698FF</color>
<color>#808000</color>
<color>#8D38C9</color>
<color>#ADD8E6</color>
<color>#F660AB</color>
<color>#F87217</color>
<color>#F9B7FF</color>
<color>#FFA500</color>
<color>#FFE87C</color>
<color>#8E35EF</color>
</std:colors>
<xsl:variable name="colors" select="document('')/*/std:colors"/>
<xsl:key name="testidKey" match="testid" use="text()"/>
<xsl:variable name="std:colorList">
<xsl:for-each select="//testid">
<xsl:if test="generate-id() = generate-id(key('testidKey', text())[1])">
<xsl:variable name="pos" select="position() mod 20"/>
<xsl:element name="color">
<xsl:attribute name="testid"><xsl:value-of select="."/></xsl:attribute>
<xsl:value-of select="$colors/color[$pos + 1]"/>
</xsl:element>
</xsl:if>
</xsl:for-each>
</xsl:variable>
<xsl:template match="/">
<html>
<head>
<style>
table {
font-family:verdana;
font-size:60%;
font-weight:bold;
align:center;
white-space: nowrap;
}
th, td {
border: solid black 1px ;
padding: 3px;
border-spacing:2px;
border-collapse: collapse;
width: 100px;
}
th {
color:green;
}
<xsl:choose>
<xsl:when test="function-available('msxsl:node-set')">
<xsl:apply-templates select="msxsl:node-set($std:colorList)/color" mode="addTRclassToCSS"/>
</xsl:when>
<xsl:when test="function-available('exslt:node-set')">
<xsl:apply-templates select="exslt:node-set($std:colorList)/color" mode="addTRclassToCSS"/>
</xsl:when>
<xsl:otherwise>
<xsl:variable name="colorList" select="$std:colorList"/>
<xsl:apply-templates select="$colorList" mode="addTRclassToCSS"/>
</xsl:otherwise>
</xsl:choose>
</style>
</head>
<body>
<table>
<tr>
<xsl:for-each select="/NewDataSet/defects[1]/*">
<th>
<xsl:value-of select="name(.)"/>
</th>
</xsl:for-each>
</tr>
<xsl:apply-templates select="*"/>
</table>
</body>
</html>
</xsl:template>
<xsl:template match="/NewDataSet/defects">
<tr>
<xsl:attribute name="class">testid<xsl:value-of select="testid"/></xsl:attribute>
<xsl:for-each select="*">
<td>
<xsl:value-of select="."/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
<xsl:template match="color" mode="addTRclassToCSS">
tr.testid<xsl:value-of select="@testid"/> {
color:<xsl:value-of select="."/>;
}
</xsl:template>
</xsl:stylesheet>
如果我正确地跟踪你的情况,这是我的建议:
使用XML“testid”元素中的数据作为您分配给XSLT中<h1>
标记的类属性的值。 然后使用css来定义与特定testid值一起使用的颜色。
由于在您的示例中,您的“testid”值都是数字,因此请记得为类名提供硬编码的字母前缀。 CSS不喜欢以数字开头的类名。
假定testid的111应该是蓝色的,其他的都是红色的,然后试试这个:
<?xml version="1.0" encoding="iso-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:template match="/">
<html>
<head>
<style>
h1.header{
font-family:verdana;
font-size:60%;
color:green
}
h1.testid111 {
font-family:verdana ;font-size:60%;color:blue
}
h1.testid999 {
font-family:verdana ;font-size:60%;color:red
}
</style>
</head>
<body>
<table BORDER="1" CELLPADDING="3" CELLSPACING="2" WIDTH="100">
<tr>
<xsl:for-each select="/NewDataSet/defects[1]/*">
<td nowrap="nowrap" width="70">
<h1 class="header">
<b>
<xsl:value-of select="name(.)"/>
</b>
</h1>
</td>
</xsl:for-each>
</tr>
<xsl:apply-templates select="*"/>
</table>
</body>
</html>
</xsl:template>
<xsl:template match="/NewDataSet/defects">
<xsl:variable name="class">
<xsl:text>testid</xsl:text><xsl:value-of select="testid"/>
</xsl:variable>
<tr>
<xsl:for-each select="*">
<td nowrap="nowrap" width = "70">
<h1 class='{$class}'>
<b>
<xsl:value-of select="."/>
</b>
</h1>
</td>
</xsl:for-each>
</tr>
</xsl:template>
</xsl:stylesheet>
链接地址: http://www.djcxy.com/p/58413.html
上一篇: XSLT to transform to HTML and format the HTML based on data in XML