excelSetFormulaeWithinFile (Excel Verification, Manipulation & Persistence)
Compatible with:
- Purpose
- This command is used to create/set the formula in the cells identified using the variable provided in the 'Target' field.
The formula string should always be in the form of the excel supported formulae without '='.
For eg., you want to set a formula for perforimg SUM operation for the values ranging from A1 to A5, you need to specify as SUM(A1:A5) - Syntax
- excelSetFormulaeWithinFile(variableHoldingWorksheetRangeHandle||variableHoldingRangeOffset,formulaString)
- Target
- variableHoldingWorksheetRangeHandle||variableHoldingRangeOffset
- Value
- formulaString
- Return Value
- N/A
- Errors & Exceptions
-
Condition Error/Exception Message Variable not Mapped The variable passed as input does not hold any worksheet range. Invalid Range Offset The Range Offset provided as input is invalid for the given range.