Lucee Function Reference
spreadsheetsetactivesheet()
Sets the given sheetName as the currently active sheet
Example
spreadsheetsetactivesheet(org.cfpoi.spreadsheet.Spreadsheet spreadsheet,string sheetName):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 |
sheetName | string | Yes | Name of an existing sheet within the spreadsheet |