AutoFillRange

This activity allows users to automatically fill specified ranges in an Excel sheet, including predefined formulas. It operates within the Excel Scope activity.

Properties

INPUT

Destination Range: *Specify the “range” where the data should be auto filled in the designated sheet. This parameter accepts values in the “String” data type. 

Sheet Name: *Specify the “SheetName” where the data needs to be processed. This parameter accepts values in the “String” datatype.”

Source Range: *Specify the source range from which the values will be copied. The input for this range must be provided in the “String” data type.

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.

Utilization of AutoFillRange

Download the sample excel sheet. 

1. To fill a range with a single cell value:

For example, let’s say we have a column titled “Remarks,” and we want to auto-fill it with the value “20.”

Steps:
a. Add the “AutoFill Range” activity, ensuring it is used within the “Excel Scope.”
b. Specify the “Source Range” as C3.
c. Specify the “Destination Range” as C3:C10.
d. Provide the sheet name and execute the activity.

Result: The range C3:C10 will be auto filled with the value 20.

2. To auto-fill a range with a predefined formula for incrementing values:

For example, let’s say we have a column titled “Remarks,” and we want to increment values across the range. (Refer to the attached sheet.)

Steps:
a. Add the “AutoFill Range” activity, ensuring it is used within the “Excel Scope.”
b. Specify the “Source Range” as C2:C10.
c. Specify the “Destination Range” as C2:C10.
d. Provide the sheet name and execute the activity.

Result: The range C2:C10 will be auto filled with incremented values based on the predefined formula.