Hi,
How to insert empty rows in excel based on condition.
Use the following activity -
If condition then
insert row
End If
2 Likes
Karthik already mentioned you the best way if you just need add row in excel.
But if you are reading the data of the Excel in a datatable, then you can just Add Row to your Datatable based on your condition and write it back.
If condition Then
Add Data Row activity
End If