-
-
Notifications
You must be signed in to change notification settings - Fork 36
setActiveSheet
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 )
-
workbook
spreadsheet object
Chainable? Yes.
spreadsheet = New spreadsheet();
workbook = spreadsheet.new(); // creates "sheet1" by default
spreadsheet.createSheet( workbook,"sheet2" );
spreadsheet.createSheet( workbook,"sheet3" );
spreadsheet.setActiveSheet( workbook,"sheet2" );