Execution stop - Insert Excel Row

[Saud_Albakhit]

i am using studioX.

i am using insert row activity when certain criteria met inside for each excel row activity. however, the execution ends after the row inserted. the row inserted in the right place but I don’t know why the execution stop even though there are multiple rows filled with data after the new inserted row, which is empty when it inserted.

Note:
For each excel row range is set to be the entire excel sheet.
every row in my excel that already has data before the execution start, and it has column named “Level” with values 1,2, or 3 across the rows in this column.
if new row inserted in the middle or something, initially has no data, but i am switch activity with (default, 1,2,3)
so if a new inserted row after the current iteration, it should execute the default activities.

So i don’t know why it stopped even though execuation works normal until it insert new row.

I am guessing it think the table ends?

[Anil_G (Anil Gorthi)]

@Saud_Albakhit

Can you please show your workflow screenshots here

Cheers

[Saud_Albakhit]

As i was expecting the automation stop because there is an empty row inserted in the middle of my sheet and it think the table ends there.

So i found the solution in other discussion post where i need to write in “where to write” field in write cell activity:
Excel.Sheet(“Sheet1”).Cell(“A”+(CurrentIndex+2).ToString)

it worked but i think my excel and column header are declared so why i need to write the name of the sheet and Column A while i can write the exact name i have in my excel.