How to Autofill by Using UIPATH

Help Studio
1

image
image839×859 36.2 KB

As you can see in the image, there are information from Cell B2:C17
And by using “Write Cell” in UiPath, I made A2 cell “=B2&C2”.

When I use Excel and double click the Fill Handle at A2 cell, it automatically makes every formula. For example, A3 cell to “=B3&C3”.

Is there any way that I can use UiPath and put the double click function.
If there is other way to make Formula from A2:A600, you can give me advice freely.

2

@goag2413,

Use Fill Range activity for this.

image
image437×144 2.74 KB

1 Like
3

Hi @goag2413

Use the AutoFill Range activity :

  1. Use Write Cell to enter =B2&C2 in A2.
  2. Use AutoFill Range, set Source Range as A2, and Fill Range as A2:A600.
4

Hey @goag2413 i"m attaching sample workflow that will help you.
on auto filling method
Auto fill Range (2).zip (123.6 KB)

This image displays a workflow in UiPath for reading data from an Excel file, writing the count of rows, writing a cell formula, and filling a range in the Excel application. (Captioned by AI)
This image displays a workflow in UiPath for reading data from an Excel file, writing the count of rows, writing a cell formula, and filling a range in the Excel application. (Captioned by AI)641×475 21.3 KB

cheers

5

Hello @goag2413 welcome to the forum comunity,
For your query you can autofill using “write cell” Activity only if you know the count of the rows in your excel.

Please refer bellow screenshot for more understanding

The image depicts a series of activities in a UiPath automation workflow for reading data from an Excel file, writing a concatenated value to a specific cell range, and outputting a comment. (Captioned by AI)
The image depicts a series of activities in a UiPath automation workflow for reading data from an Excel file, writing a concatenated value to a specific cell range, and outputting a comment. (Captioned by AI)599×517 15.2 KB

Do let me know if you have any further doubts, or if it helps mark it as solution so that it helps other as well.

Happy Automation.

6

Hi @goag2413 , You can use excel activities to achieve your task. Please replicate the steps from the image attached.

This image depicts an automation workflow for processing rows in an Excel file, combining values from two columns, and writing the results back into the same sheet. (Captioned by AI)
This image depicts an automation workflow for processing rows in an Excel file, combining values from two columns, and writing the results back into the same sheet. (Captioned by AI)612×813 47.2 KB