<!-- An example that shows how to assign fonts to each cell and change the style of the cell. Also shows how to merge cells and set the column span for a cell. --> <cf_xls_workbook SaveAsName="generate3.xls"> <cf_xls_sheet Name="Sheet1" columnwidths="25,25,25,25,25,25"> <cf_xls_row> <!-- Font is specified with the font attribute in a format similiar to css styles Possible settings for a font include: family:Name of Font; size:integer size of font; weight:Normal or Bold; underline:single or singleaccounting or double or doubleaccounting; color:One of the defined Colors(see below);style:normal or italic; Colors include: GRAY,BLACK,BLUE,BLUE_GREY,BRIGHT_GREEN,BROWN,CORAL,CORNFLOWER_BLUE,DARK_BLUE, DARK_GREEN,DARK_RED,DARK_TEAL,DARK_YELLOW,GOLD,GREEN,GREY_25_PERCENT, GREY_40_PERCENT,GREY_50_PERCENT,GREY_80_PERCENT,INDIGO,LAVENDER, LEMON_CHIFFON,LIGHT_BLUE,LIGHT_CORNFLOWER_BLUE,LIGHT_GREEN, LIGHT_ORANGE,LIGHT_TURQUOISE,LIGHT_YELLOW,LIME,MAROON,OLIVE_GREEN, ORANGE,ORCHID,PALE_BLUE,PINK,PLUM,RED,ROSE,ROYAL_BLUE,SEA_GREEN,SKY_BLUE, TAN,TEAL,TURQUOISE,VIOLET,WHITE,YELLOW --> <cf_xls_cell font="family:Arial;Size:14;weight:normal;color:red;">Red Size 14</cf_xls_cell> <cf_xls_cell font="family:Arial;Size:14;weight:normal;style:italic;">Size 14 Italic</cf_xls_cell> <cf_xls_cell font="family:Courier;Size:8;weight:normal;style:italic;">Courier Size 8 Italic</cf_xls_cell> <cf_xls_cell font="family:Courier;Size:8;weight:Bold;style:normal;">Courier Size 8 Bold</cf_xls_cell> <!-- The style for a cell is specified with the style attribute similiar to css styles Possible setting for the style attribute include: align:left or center or right; vAlign:top or center or bottom; wrapText:Yes or No; backgroundColor:One of the defined Colors; border:One of the defined Borders; borderColor:One of the defined Colors; bottomBorder:One of the defined Borders; bottomBorderColor:One of the defined Colors; topBorder:One of the defined Borders; topBorderColor:One of the defined Colors; leftBorder:One of the defined Borders; leftBorderColor:One of the defined Colors; rightBorder:One of the defined Borders; rightBorderColor:One of the defined Colors; Borders include: None,DASH_DOT,DASH_DOT_DOT,DASHED,DASH_DOT_DOT,DASH_DOT_DOT,DASH_DOT_DOT, MEDIUM,MEDIUM_DASH_DOT,MEDIUM_DASH_DOT_DOT,MEDIUM_DASHED,SLANTED_DASH_DOT, THICK,THIN --> <cf_xls_cell style="backgroundColor:black;" font="color:white;">Black and White</cf_xls_cell> <cf_xls_cell style="backgroundColor:Grey_25_Percent;" font="underline:double;">Grey Double Underline</cf_xls_cell> </cf_xls_row> <cf_xls_row height="5"> <cf_xls_cell style="align:right;">Align Right</cf_xls_cell> <cf_xls_cell style="align:center;">Align center</cf_xls_cell> <cf_xls_cell style="align:left;">Align left</cf_xls_cell> <cf_xls_cell style="valign:top;">VAlign Top</cf_xls_cell> <cf_xls_cell style="valign:center;">VAlign Center</cf_xls_cell> <cf_xls_cell style="valign:bottom;">VAlign Bottom</cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell style="align:right;valign:top;">Wrapped Text:</cf_xls_cell> <cf_xls_cell style="wrapText:Yes;">To be, or not to be: that is the question:Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And by opposing end them. To die: to sleep;</cf_xls_cell> <cf_xls_cell style="align:right;valign:top;">Not Wrapped:</cf_xls_cell> <cf_xls_cell style="wrapText:No;">To be, or not to be: that is the question:Whether 'tis nobler in the mind to suffer The slings and arrows of outrageous fortune, Or to take arms against a sea of troubles, And by opposing end them. To die: to sleep;</cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell></cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell>Borders:</cf_xls_cell> <cf_xls_cell style="border:THICK">Thick Border</cf_xls_cell> <cf_xls_cell style="border:MEDIUM">Medium Border</cf_xls_cell> <cf_xls_cell style="border:THIN;borderColor:red">Thin Red Border</cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell></cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell>Single Borders:</cf_xls_cell> <cf_xls_cell style="leftborder:MEDIUM;leftborderColor:red">Left Red</cf_xls_cell> <cf_xls_cell style="topborder:MEDIUM;topborderColor:maroon">Top Maroon</cf_xls_cell> <cf_xls_cell style="rightborder:MEDIUM;rightborderColor:Blue">Right Blue</cf_xls_cell> <cf_xls_cell style="bottomborder:MEDIUM;bottomborderColor:Green">Bottom Green</cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell></cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell>Column Span:</cf_xls_cell> <cf_xls_cell style="border:thick" colspan="3">Should Span 3 Columns</cf_xls_cell> <cf_xls_cell >Cell 4</cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell></cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell>Merge Cells:</cf_xls_cell> <!-- This cell shows how to ID/Label a cell so that we can reference this cell later. Use of the referenceID include setting merged cells, prntareas, repeating cells, freeze cells, etc... --> <cf_xls_cell ID="cell1" style="border:thick">Merging Multiple Rows/Cells</cf_xls_cell> <cf_xls_cell ></cf_xls_cell> <cf_xls_cell ></cf_xls_cell> <cf_xls_cell ></cf_xls_cell> </cf_xls_row> <cf_xls_row> <cf_xls_cell>Continued:</cf_xls_cell> <cf_xls_cell ></cf_xls_cell> <cf_xls_cell ></cf_xls_cell> <cf_xls_cell ID="cell2"></cf_xls_cell> <cf_xls_cell >Cell 4</cf_xls_cell> </cf_xls_row> <!-- Cells can be merged by using the cf_xls_mergedcells tag. The idFrom and idTo attributes are cell referenceIDs (see above). The area enclosed in the idFrom to idTo references can be on one row, or span rows and columns. The only requirement is the idTo is either greater in column position or row position than idFrom. --> <cf_xls_mergedcells idFrom="cell1" idTo="cell2" /> </cf_xls_sheet> </cf_xls_workbook>