by Kaustubh Zoal (10 Submissions)
Category: Miscellaneous
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 21st June 2002
Date Added: Mon 8th February 2021
Rating: 
(1 Votes)
Sample of generating HTML report using the XML & XSL files
VBcoders
<html>
<body style="overflow: auto;">
<script type="text/javascript">
// Load XML
var xml = new ActiveXObject("MSXML2.DOMDocument");
xml.preserveWhiteSpace = true;
xml.async = false;
xml.load("scan.xml");
// Load the XSL
var xsl = new ActiveXObject("MSXML2.DOMDocument");
xsl.async = false
xsl.load("scan.xsl");
// Transform
var htmlContent =xml.transformNode(xsl);
document.open;
document.write(htmlContent);
</script>
</body>
</html>
----------------------------------------------------------------------------------------------------------------------------------------------------------------Scan.XML
<?xml version="1.0"?>
<ScanInfo>
<BookPath>D:\Data</BookPath>
<Scan>
<ScanID>8888888800000001</ScanID>
<RBookFileName>r8888888800000001.tif</RBookFileName>
<PBookFileName>p8888888800000001.tif</PBookFileName>
<MBookFileName>m8888888800000001.tif</MBookFileName>
<PageNumber>1</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000002</ScanID>
<RBookFileName>r8888888800000002.tif</RBookFileName>
<PBookFileName>p8888888800000002.tif</PBookFileName>
<MBookFileName>m8888888800000002.tif</MBookFileName>
<PageNumber>2</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000003</ScanID>
<RBookFileName>r8888888800000003.tif</RBookFileName>
<PBookFileName>p8888888800000003.tif</PBookFileName>
<MBookFileName>m8888888800000003.tif</MBookFileName>
<PageNumber>3</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000004</ScanID>
<RBookFileName>r8888888800000004.tif</RBookFileName>
<PBookFileName>p8888888800000004.tif</PBookFileName>
<MBookFileName>m8888888800000004.tif</MBookFileName>
<PageNumber>4</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000005</ScanID>
<RBookFileName>r8888888800000005.tif</RBookFileName>
<PBookFileName>p8888888800000005.tif</PBookFileName>
<MBookFileName>m8888888800000005.tif</MBookFileName>
<PageNumber>5</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000006</ScanID>
<RBookFileName>r8888888800000006.tif</RBookFileName>
<PBookFileName>p8888888800000006.tif</PBookFileName>
<MBookFileName>m8888888800000006.tif</MBookFileName>
<PageNumber>6</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000007</ScanID>
<RBookFileName>r8888888800000007.tif</RBookFileName>
<PBookFileName>p8888888800000007.tif</PBookFileName>
<MBookFileName>m8888888800000007.tif</MBookFileName>
<PageNumber>7</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000008</ScanID>
<RBookFileName>r8888888800000008.tif</RBookFileName>
<PBookFileName>p8888888800000008.tif</PBookFileName>
<MBookFileName>m8888888800000008.tif</MBookFileName>
<PageNumber>8</PageNumber>
</Scan>
<Scan>
<ScanID>8888888800000009</ScanID>
<RBookFileName>r8888888800000009.tif</RBookFileName>
<PBookFileName>p8888888800000009.tif</PBookFileName>
<MBookFileName>m8888888800000009.tif</MBookFileName>
<PageNumber>9</PageNumber>
</Scan>
<Scan>
<ScanID>888888880000000a</ScanID>
<RBookFileName>r888888880000000a.tif</RBookFileName>
<PBookFileName>p888888880000000a.tif</PBookFileName>
<MBookFileName>m888888880000000a.tif</MBookFileName>
<PageNumber>10</PageNumber>
</Scan>
<Scan>
<ScanID>888888880000000b</ScanID>
<RBookFileName>r888888880000000b.tif</RBookFileName>
<PBookFileName>p888888880000000b.tif</PBookFileName>
<MBookFileName>m888888880000000b.tif</MBookFileName>
<PageNumber>11</PageNumber>
</Scan>
<Scan>
<ScanID>888888880000000c</ScanID>
<RBookFileName>r888888880000000c.tif</RBookFileName>
<PBookFileName>p888888880000000c.tif</PBookFileName>
<MBookFileName>m888888880000000c.tif</MBookFileName>
<PageNumber>12</PageNumber>
</Scan>
<Scan>
<ScanID>888888880000000d</ScanID>
<RBookFileName>r888888880000000d.tif</RBookFileName>
<PBookFileName>p888888880000000d.tif</PBookFileName>
<MBookFileName>m888888880000000d.tif</MBookFileName>
<PageNumber>13</PageNumber>
</Scan>
<Scan>
<ScanID>888888880000000e</ScanID>
<RBookFileName>r888888880000000e.tif</RBookFileName>
<PBookFileName>p888888880000000e.tif</PBookFileName>
<MBookFileName>m888888880000000e.tif</MBookFileName>
<PageNumber>14</PageNumber>
</Scan>
<Scan>
<ScanID>888888880000000f</ScanID>
<RBookFileName>r888888880000000f.tif</RBookFileName>
<PBookFileName>p888888880000000f.tif</PBookFileName>
<MBookFileName>m888888880000000f.tif</MBookFileName>
<PageNumber>15</PageNumber>
</Scan>
</ScanInfo>
--------------------------------------------------------------------------------SCan.XSL
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/"><html>
<style>
.head
{
vertical-align: middle;
text-align: center;
font-size: 10pt;
font-weight: bold;
font-family: verdana;
letter-spacing: 1px;
background-color: #bed5f1;
color: #0000ff;
}
.scanid
{
vertical-align: middle;
text-align: center;
font-size: 10pt;
font-family: verdana;
letter-spacing: 1px;
color: #0000ff;
border-bottom: 1px solid #429987;
border-right: 1px solid #429987;
background-color: #eae5c2;
}
.rbook
{
vertical-align: middle;
text-align: center;
font-size: 10pt;
color: #ff00ff;
font-family: verdana;
letter-spacing: 1px;
border-bottom: 1px solid #429987;
border-right: 1px solid #429987;
background-color: #f7fbcd;
}
.pbook
{
vertical-align: middle;
text-align: center;
font-size: 10pt;
color: #000000;
font-family: verdana;
letter-spacing: 1px;
border-bottom: 1px solid #429987;
border-right: 1px solid #429987;
background-color: #eae5c2;
}
.mbook
{
vertical-align: middle;
text-align: center;
font-size: 10pt;
color: #0000ff;
font-family: verdana;
letter-spacing: 1px;
border-bottom: 1px solid #429987;
border-right: 1px solid #429987;
background-color: #f7fbcd;
}
.page
{
vertical-align: middle;
text-align: center;
font-size: 10pt;
color: #ff00ff;
font-family: verdana;
letter-spacing: 1px;
border-bottom: 1px solid #429987;
background-color: #eae5c2;
}
.total
{
border-bottom: 3px solid #429987;
vertical-align: middle;
text-align: center;
font-size: 10pt;
letter-spacing: 1px;
font-weight: bold;
font-family: verdana;
background-color: #cdf1d6;
color: #ff0000;
}
</style>
<title><xsl:value-of select="//BookPath"/></title>
<body><xsl:apply-templates/></body></html></xsl:template>
<!-- Match for ScanInfo -->
<xsl:template match="ScanInfo">
<table border="3" cellspacing="0" align="center" cellpadding="7">
<caption><b>BookPath is => <xsl:value-of select="BookPath"/></b></caption>
<tr class="head">
<td class="head">ScanID</td>
<td class="head">RBookFileName</td>
<td class="head">PBookFileName</td>
<td class="head">MBookFileName</td>
<td class="head">PageNumber</td>
</tr>
<xsl:for-each select="Scan">
<tr>
<td class="scanid"><xsl:value-of select="ScanID"/></td>
<td class="rbook"><xsl:value-of select="RBookFileName"/></td>
<td class="pbook"><xsl:value-of select="PBookFileName"/></td>
<td class="mbook"><xsl:value-of select="MBookFileName"/></td>
<td class="page"><xsl:value-of select="PageNumber"/></td>
</tr>
</xsl:for-each>
<tr>
<td class="total"><xsl:value-of select="count(//ScanID)"/></td>
<td class="total"><xsl:value-of select="count(//RBookFileName)"/></td>
<td class="total"><xsl:value-of select="count(//PBookFileName)"/></td>
<td class="total"><xsl:value-of select="count(//MBookFileName)"/></td>
<td class="total"><xsl:value-of select="count(//PageNumber)"/></td>
</tr>
</table>
</xsl:template>
</xsl:stylesheet>
--------------------------------------------------------------------------------