Local Style

Description

Describes the style to be used for a particular cell. The sytax is similiar to CSS styles where attributes are paired with values using an equals sign and semi-colon, attribute = value;. Local styles can only be used as an attribute within the CF_XLS_Cell tag.

Syntax

<CF_XLS_Cell 
	....
	style="align:left or center or right; backgroundcolor:color (see below); 
        border:border (see below); bordercolor:color (see below);
	bottomborder:border (see below); bottombordercolor:color (see below);
        dataformat:data format (see below);
	leftborder:border (see below); leftbordercolor:color (see below);
        rightborder:border (see below); rightbordercolor:color (see below);
	topborder:border (see below); topbordercolor:color (see below);
        verticalalign:top or center or bottom; wraptext:yes or no;"
	....
	>

Attributes

Attribute Req/Opt Default Description
Align Opt left The horizontal alignment of the text.
BackgroundColor Opt   One of the defined colors. (See Colors below)
Border Opt   A type of border for the entire cell, top, right, left and bottom borders. (See Borders below)
BorderColor Opt black A color for all of the borders, top, right, left and bottom border. (See Colors below)
BottomBorder Opt   A type of border for just the bottom border. (See Borders below)
BottomBorderColor Opt black A color for just the bottom border. (See Colors below)
LeftBorder Opt   A type of border for just the left border. (See Borders below)
LeftBorderColor Opt black A color for just the left border. (See Colors below)
RightBorder Opt   A type of border for just the right border. (See Borders below)
RightBorderColor Opt black A color for just the right border. (See Colors below)
TopBorder Opt   A type of border for just the top border. (See Borders below)
TopBorderColor Opt black A color for just the top border. (See Colors below)
VerticalAlign Opt left The type of data that is contained in the cell.
  • left
  • center
  • right
WrapText Opt No Text wrapped to the cells width. The height of the row may need to be specifed for desired results.
  • Yes - the text will be wrapped to stay within the bounds of the cell's width.
  • No - the text will not be wrapped and may spill into the next cell.

Usage

Borders:
  • 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
Colors:
  • 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

Example

See the examples page.