Tags · Functions · Objects
Lucee Function Reference
Choose a function:
see all functions

Function SPREADSHEETSETACTIVESHEETNUMBER

Sets the sheet at the given position as the currently active sheet

Example

spreadsheetsetactivesheetnumber(org.cfpoi.spreadsheet.Spreadsheet spreadsheet,string sheetIndex):void

Arguments

The arguments for this function are set. You can not use other arguments except the following ones.
Name Type Required Description
spreadsheet org.cfpoi.spreadsheet.Spreadsheet  Yes Target Spreadsheet  
sheetIndex string  Yes Sheet Position. Value between 1 and the total number of sheets in the spreadsheet