Write after the last row on excel

Help Studio
, ,
1

Hi,
i want to know the last row writed on excel to write after.

3
3597×602 12.4 KB

¿It´s possible to put something up of write range to know the last row writed on excel and write the answer in the cell where you put the cell to write in write range?

Thanks.

1 Like
2

Hi @jfernandez

You can Try with Append Range activity

Regards
Gokul

3

Hi @jfernandez
there are two ways to achieve this

  1. using append range activity ( Direct method)
  2. finding last row of excel by using read range …storing that count in a variable
    and later passing that in ur write range activity

Thanks

4

Also @jfernandez

please find an example for ur reference

Thanks

5

Hello @jfernandez ,

You can use append range to append the values to the existing excel (it will write into next row of the existing excel file).

If you want to know the last row index then you can use the below expression :
Index_val = item.Rows.Count+2 .

(Here +2 is added because excel index starts with 1 & 1st line will be a header usually)

1 Like
6

Thanks it worked.

7

@jfernandez ,

Great! Which ever method is worked for you, you can mark it as solution for others reference.

Regards,
Rohith

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.