setActiveSheet

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 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

Chainable? Yes.

Example

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