Copy Paste Range
Properties
INPUT
Source SheetName: *Specify the “SheetName” from which the range of values needs to be copied, and it accepts value in “String” datatype.
Source Range: *Specify the range of cells from the source sheet to be copied and it accepts values in “String” datatype.
Destination Sheet: *Specify the destination sheet name where the range of values to be pasted and it accepts values in “String” datatype.
Destination Cell: *Specify the “cell” number from the destination sheet to paste the values and it accepts values in “String” datatype.
Options: This parameter allows you to choose what to be read and copied from the range of values. Select the values from the drop-down,
Value: Allows to copy and paste only the values from the specified range.
Formula: Allows to copy and paste values along with their formulas from the specified range.
Number Format: Allows to copy and paste the numeric values along with their number formatting, such as currency, percentage, or decimal places.
Cell Format: Allows to copy and paste the cell formatting, including font styles, background colors, borders, and alignment, without copying the actual cell values or formulas.
All: Allows you to copy and paste everything from the specified range, including values, formulas, number formatting, and cell formatting to the destination sheet.
MISC
DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.
SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.
Version: It indicates the version of the feature being used.
OUTPUT
Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.
* Represents mandatory fields to execute the workflow.
