Can anybody help me in modification of xls stylesheet to merge two cells of a row

Akriti Srivastava · January 31st, 2013, 05:56 AM

I have built a simple style sheet coded as follows:

Code:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"><xsl:template match="/">
  <HTML>
    <HEAD>
      <STYLE type="text/css">
        TABLE{table-layout: automatic; width:100%} .tblHeader{background-color:RGB(192,192,192);font-weight:bold} 
      </STYLE>
    </HEAD>
    <BODY>
      <TABLE border="1">
        <THEAD><TR class="tblHeader">
          <TD colspan="16" align="center">
            LA MARTINIERE GIRLS' COLLEGE, LUCKNOW
          </TD>
          <!-- <TD>F2</TD>
          <TD>F3</TD>
          <TD>F4</TD>
          <TD>F5</TD>
          <TD>F6</TD>
          <TD>F7</TD>
          <TD>F8</TD>
          <TD>F9</TD>
          <TD>F10</TD>
          <TD>F11</TD>
          <TD>F12</TD>
          <TD>F13</TD>
          <TD>F14</TD>
          <TD>F15</TD>
          <TD>F16</TD>-->
        </TR>
        </THEAD>
        <TBODY>
          <xsl:for-each select="NewDataSet/Table1">
            <TR><xsl:choose> 
              <xsl:when test="position() mod 2 = 1"> 
                <xsl:attribute name="class">row1</xsl:attribute> 
              </xsl:when>
              <xsl:otherwise>
                <xsl:attribute name="class">row2</xsl:attribute> 
              </xsl:otherwise> </xsl:choose>
              <TD><xsl:value-of select="F1"/></TD>
              <TD><xsl:value-of select="F2"/></TD>
              <TD><xsl:value-of select="F3"/></TD>
              <TD><xsl:value-of select="F4"/></TD>
              <TD><xsl:value-of select="F5"/></TD>
              <TD><xsl:value-of select="F6"/></TD>
              <TD><xsl:value-of select="F7"/></TD>
              <TD><xsl:value-of select="F8"/></TD>
              <TD><xsl:value-of select="F9"/></TD>
              <TD><xsl:value-of select="F10"/></TD>
              <TD><xsl:value-of select="F11"/></TD>
              <TD><xsl:value-of select="F12"/></TD>
              <TD><xsl:value-of select="F13"/></TD>
              <TD><xsl:value-of select="F14"/></TD>
              <TD><xsl:value-of select="F15"/></TD>
              <TD><xsl:value-of select="F16"/></TD>
            </TR></xsl:for-each>
        </TBODY>
      </TABLE>
    </BODY>
  </HTML>
</xsl:template></xsl:stylesheet>

This style sheet is used to provide styling to an excel sheet. Please help me to modify the sheet in such a way that I can get an excel sheet having some cells merged eg if there are 15 columns then for a particular row 4 I want col1, col2, col3 to be merged and highlighted by a color and for another Rows, they should not be merged.