XLSAdapter.com

• Home > 
• Documentation > 
• CF_XLS_Sheet > 

CF_XLS_Sheet

Description

Creates a new sheet within a workbook. This tag can only be used within the CF_XLS_Workbook tag.

Syntax

<CF_XLS_Sheet
   ColumnWidths = "yes" or "no"
   DisplayGridLines = "yes" or "no"
   Name = "filename">
	 
	 ....XLSAdapter tags....
	 
</CF_XLS_Row>

Attributes

Attribute	Req/Opt	Default	Description
ColumnWidths	Opt		A comma seperated list of integers representing the width of each column. The width is specified in roughly 1 unit = 1 character. Due to how Excel handles width, this will work out pretty well for the default fonts, larger fonts may require greater widths.
DisplayGridLines	Opt	Yes	Determines whether the gridlines are visible when viewing the workbook. yes: gridlines are visible. no: gridlines are not visible.
Name	Opt	SheetN	Name of the sheet you are creating. If the Name attribute is omitted the sheet is named SheetN where "N" is the number of the sheet starting with 1.

Usage

You can use the following ColdFusion form control tags within the CF_XLS_Sheet tag:

• CF_XLS_Row Used to create a new row within the sheet.
• CF_XLS_FreezePanes Used to freeze a column and/or row.
• CF_XLS_MergedCells Used to merge an area of cells.
• CF_XLS_Header Used to define a header for a sheet.
• CF_XLS_Footer Used to define a footer for a sheet.
• CF_XLS_RepeatingRows Used to make rows repeat on each page when printed.
• CF_XLS_PrintSetup Used to set print options.
• CF_XLS_PrintArea Used to set the area to be printed.

Example

See the examples page.