Find the last cell with data and impute to the next cell

Help
1

I can find the amount of lines that are filled in excel using:
read range
test.Rows.Count.ToString

now my doubt is, how do I impute data in the next available line? knowing that I have 14 lines filled?

1 Like
2

Hi @Beatriz,

You can decide where to put data in the range selection:
image

If you put A14, it will take that as a starting point :slight_smile:

3

but I will have to impute several data for excel, I would do it in an automatic way, because I will not know how many rows excel has

4

You can replace the “A1” with something like that for dynamic value:

"A" + test.Rows.Count.ToString
5

text.xaml (5.7 KB)
Pasta1.xlsx (10.4 KB)

did not work, could you see if I’m doing something wrong?

6

he is not able to impute the word in the next available cell

7

It looks like the problem may be your spreadsheet. When I download it and check the number of rows UiPath is reading it was over 10K and there was text written several thousand rows after the bulk of the data. Clean this up and the method @loginerror described will work just fine (it’s working already in your automation actually). Clean up the spreadsheet and your issues should resolve themselves without much effort.

8

i have problem too. “test” is it VB? then should it be int32? then what activity should i do to declare the VB?

thanks