#foreach( $col in $sheet.getColumns() ) #set( $id = "id_$col.getId()") #set( ${foreach.count}0 = ${foreach.count} + -1) #end #set( $row = $sheet.getHeader() ) #set( $rid = $row.getId() ) #foreach( $cell in $row.getCells() ) #set( $cid = $cell.getId() ) #end #foreach( $col in $sheet.getColumns() ) #end #foreach( $row in $sheet.getRows(1)) #set ($rowcolor = "") #set ($rowcolor = $sheet.pickColorForRow($row)) #set( $rid = $row.getId() ) #foreach( $cell in $row.getCells() ) #set( $cid = $cell.getId() ) ##find the color for this cell #set ($color = "") #set ($color = $sheet.pickColor($cell.getText())) ##default back to row color if it exists #if ($color.length() == 0) #set ($color = $rowcolor) #end #end #end
$col.getText()
-1) style="height: ${row.getHeight()}px"#end id="$rid" #if($caneditspreadsheet) onclick="selectRow('$rid') #end">
$!cell.getText()
 
-1) style="height: ${row.getHeight()}px"#end id="$row.getId()" #if($caneditspreadsheet) onclick="selectRow('$row.getId()')#end">${foreach.count} 0) style="background-color: $color;" #end >
0) style="background-color: $color;" #end >$!cell.getText()