BI Publisher RTF Template Column Span

BI Publisher RTF Template, Merge Columns Dynamically

We shall see how to merge cells dynamically in Excel output with RTF template.

Use below code for defining the column span

<xsl:attribute xdofo:ctx="block" name="number-columns-spanned">        

       <xsl:value-of select="//CELL_TO_BE_MERGED"/>

</xsl:attribute>

In effect our RTF template will look as mentioned below:-

 Sample XML for testing is below:- 

<?xml version="1.0" encoding="UTF-8"?>

<CELLMERGE>

                <CELL_TO_BE_MERGED>3</CELL_TO_BE_MERGED>

                <CONTENT> THIS IS MERGED CELL </CONTENT>

</CELLMERGE>

Report output is shown below:-

Cells A1,B1,C1 are merged and content spans across 3 cells :-