Skip to content
Julian Halliwell edited this page Sep 20, 2021 · 5 revisions

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" );
Clone this wiki locally