Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

Auto Fill

Fills cells with data based on data in other cells using the AutoFill feature in Excel. Similar to double-clicking the Fill Handle in Excel to copy the formula from one or more adjacent cells down to the cells in the rows with data. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity
  • Select source - Click Plus on the right side of the field and then, from the menu, select Indicate in Excel to open the file and select one or more adjacent cells directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.

    If the source is in a table and empty cells followed by cells with data are encountered, auto filling does not stop at the first cell with data. For example, if range A1:B6 is formatted as a table, cells A3:A5 are empty, and cell A6 contains data, selecting A2 as the source fills cells A3:A6, overwriting cell A6.

Properties Panel

Common

  • DisplayName - The name displayed for the activity in the Designer panel.

Input

  • Start range - See Select source in the body of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.