excelSetWorksheetContextWithinWorkbook (Excel Verification, Manipulation & Persistence)
Compatible with:
- Purpose
- This command can be used to create a new worksheet context within the workbook in memory with a name as specified in the 'Value' field
- Syntax
- excelSetWorksheetContextWithinWorkbook(variableHoldingWorkbookHandle||nameOfWorksheet,
- variableHoldingWorksheetHandle)
- Target
- variableHoldingWorkbookHandle||nameOfWorksheet
- Value
- variableHoldingWorksheetHandle
- Return Value
- N/A
- Errors & Exceptions
-
Condition Error/Exception Message Non-existing File The sheet name provided in the target does not exist in the excel workbook Variable Not Mapped The variable passed in the target does not map to any excel file. Empty Sheet Name Sheet name should not be empty.