createSheet - cfsimplicity/spreadsheet-cfml GitHub Wiki

Creates a new sheet within a spreadsheet workbook.

createSheet( workbook[, sheetName [, overwrite ] ] )

Required arguments

• workbook spreadsheet object

Optional arguments

• sheetName string: the name of the new sheet to create. If omitted a unique name is generated.
• overwrite boolean default=false: whether to replace an existing sheet with the same name.

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.createSheet( workbook,"New" );