Fill Columns

This action is used to fill a range of columns with a target formula.

Properties

Input

  • Excel Document: File name for the target Excel document.

  • WorkSheet: The target worksheet name.

  • Cell Range: The target name.

  • Formula: The formula to be used when filling the columns.

The range needs to be specified as an A1 notation and span a single row. Example "A1:E1".

Misc

  • Display Name: action display name in your implementation project

  • Wait Before: number milliseconds robot to wait before executing the action.

  • Wait After: number milliseconds robot to wait until moving to the next action.

  • Abort on Error: True/False

  • Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

  • Fill columns with a formula to calculate their sum.

  • Fill columns with a formula to calculate their division.

  • Fill columns with a formula to calculate their subtraction.

Examples of Using Fill Columns

Example

Watch the robot in action:

You can check and download the example from here:

PreviousFill RowsNextDelete Sheet

Last updated