Loop Datarow and update new row under the specific row

Hi I understand that adding or removing rows in datatable while looping is impossible. But I have a criteria such that:

  1. Checking row meets condition
  2. If row does not meet condition, I have to check for additional data at another application and add a new row below that specific row with the new updates.
  3. In addition, I have to keep the formatting of the excel worksheet (e.g. cell border, cell colour)


You will not be able to alter datatable or any collection in FOREACH activity. However, you can use loops like while or dowhile and within that you can add or remove rows or items from the collection.

For point 3: Is see there is activity available on GO!