Insert rows in an excel file

Hi,
Please help on this!!
How to add rows in an excel file below headers,am using “Insert/delete rows”, but it is moving my headers down,my requirement is to keep the header constant and add rows below to it.

Thanks in advance.

Hi @keerthishree,

You can use Add data row acitivity.

Refer the below post on how to use add data row.

1 Like

In Insert Row activity, what is the value you are giving for the following field -

Position - The row where the insertion or removal begins. This field supports only integers or Int32 variables.

If you want to insert at 2nd row, give position as 2. And the other rows will shift down.

Regards,
Karthik Byggari

1 Like