CF_XLS_Cell

Description

Creates a new cell within a row. This tag can only be used within the CF_XLS_Row tag.

Syntax

<CF_XLS_Cell
   Colspan = "Integer"
   DataFormat = "Data Format (see below)"
   Font = "Local Font"
   ID = "Reference ID"
   Type = "string|number|date|formula"
   Style = "Local Style"
   StyleID = "ReferenceID">
	 
	 (Value of the cell.)
	 
</CF_XLS_Cell>

Attributes

Attribute Req/Opt Default Description
Colspan Opt   An integer for how many columns to span to the right of this cell.
DataFormat Opt General A string represented how the cell's value is displayed. Below are examples.
  • General
  • 0
  • 0.00
  • #,##0
  • #,##0.00
  • ($#,##0_);($#,##0)
  • ($#,##0_);[Red]($#,##0)
  • ($#,##0.00);($#,##0.00)
  • ($#,##0.00_);[Red]($#,##0.00)
  • 0%
  • 0.00%
  • 0.00E+00
  • # ?/?
  • # ??/??
  • m/d/yy
  • d-mmm-yy
  • d-mmm
  • mmm-yy
  • h:mm AM/PM
  • h:mm:ss AM/PM
  • h:mm
  • h:mm:ss
  • m/d/yy h:mm
Font Opt   A string representing the font family, size, weight and style to use for this cell. See Local Font.
ID Opt   A string/name for the current cell. The name can then be referenced later in formulas, merged cells, print areas, freezed cells and repeating rows.
Type Opt string The type of data that is contained in the cell.
  • string
  • number - any type of number. Use the dataformat attribute to format the number.
  • date - a date. Important: if the dataformat attribute is not used the date will display as a number.
  • formula - the cell's value is a formula. Important: formulas do NOT have an equals sign at the begining.
Style Opt   A string representing the style to use for this cell See Local Style.
StyleID Opt   The name of a global style defined with the CF_XLS_Style tag. If both the style and styleID attributes are defined, the cell's style will be the combination of both, with the local style (style attribute) overriding the global style.

Example

See the examples page.