Skip to content
Julian Halliwell edited this page Feb 25, 2015 · 4 revisions

Sets the active sheet (the one operations are carried out on) to the sheet specified by name or number.

setActiveSheet( workbook, sheetName )

or

setActiveSheet( workbook, sheetNumber )

##Required arguments

  • workbook spreadsheet object

##Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new(); // creates "sheet1" by default
spreadsheet.createSheet( workbook,"sheet2" );
spreadsheet.createSheet( workbook,"sheet3" );
spreadsheet.setActiveSheet( workbook,"sheet2" );

Clone this wiki locally