Lucee Function Reference
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 |