Insert row consecutively

#1

Hi,
Can anyone help me how to insert row consecutively without disturbing other row placement?

Raw data is input file,
first i read column that i want and split string from the column,
but i dont know how to insert row consecutively without disturbing other row in first column in book 1.
here is my workflow`book1.xlsx (21.3 KB)
insert rc value.xaml (10.5 KB)
RawData2.xlsx (14.8 KB)

Thank so much if somebody can help!
`

#2

Hi @mashy2

You can do this easily using Insert/ Delete Rows activity to add a row in a particular location. It will move the rest of the rows below downwards. Since you are doing this in a loop, just add one row at a time, and specify the excel row index where you want to add the row. After this activity, we can use a Write Cell activity to write the cell value. We do not need to write an entire row in your case.

I have modified the workflow you shared to get this done. Check it out…

insert rc value.xaml (7.9 KB)

Just change these properties according to the place you want to add the row and write the new data.

For Inserting row:

For Wring data to cell:

Edit: Please add this tick to your Excel Application Scope to save the excel file after this change

If this works for you, please also make sure to mark the answer as the solution too :slight_smile:

1 Like