excelClearContentsWithinFile (Excel Verification, Manipulation & Persistence)
Compatible with:
- Purpose
- This command can be used to clear the contents from the workbook/worksheet/worksheet range
- On specifying the variable having a range or range offset values, it will clear the content of the specific range/range offset values within the worksheet
- On specifying the variable having the worksheet, the content in the respective worksheet would be cleared
- On specifying the variable having the workbook, it will clear the contents of all the worksheets within the workbook
- Syntax
- excelClearContentsWithinFile
(variableHoldingWorksheetRangeHandle || variableHoldingRangeOffset (or)
variableHoldingWorksheetHandle (or)
variableHoldingWorkbookHandle) - Target
- variableHoldingWorksheetRangeHandle || variableHoldingRangeOffset (or)
variableHoldingWorksheetHandle (or)
variableHoldingWorkbookHandle - Value
- N/A
- Return Value
- N/A
- Errors & Exceptions
-
Condition Error/Exception Message Variable not Mapped The variable passed as input does not hold any workbook/worksheet/worksheet range. Invalid Range Offset The Range Offset provided as input is invalid for the given range.