Excel filling

Help Activities
, , ,
1

Hello, please help.

I have an excel file that is filled with information from other excel files every day.

the bot has to extract information from base files and paste it into a main file.

How can I make the bot write the information right in the next empty column?

image

That is, the bot begins to fill in the information from column 5, and in this way it will fill the file.

2

first, read range (dont tick “add headers”) into dt variable,

then set nextRow (integer) = dt.RowCount+1

next time you write range, write to “A”+nextRow.toString (will write to A5)

image
image1119Ă—294 13.8 KB

3

It is not always in A5, the range will increase.

The first empty row may be 6 or 20 , as time progresses the file will contain more information .

4

yes my answer is dynamic, if last row =6 ,it will fill row 7, if last row = 20 it will start from row21,

you can try it first

5

Main.xaml (10.5 KB)
this is what i mean

1st run (write to A1)
image
2nd run (will write to A4)
image

6

Hello @alexis.mendoza ,

You can also use Find First/Last row activity to find the last row and assign to a variable and you can use it in your range to append the data.

1 Like
7

i Don´t have this activity

image
image434Ă—770 18.1 KB

8

Are you using the modern designer or classic? Go to project settings and enable Modern Design Experience.

9

i don´t have thi soption …

image
for my uipath version maybe

10

Can you plz update that to studio 2022.+ version.