Hi I understand that adding or removing rows in datatable while looping is impossible. But I have a criteria such that:
- Checking row meets condition
- 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.
- In addition, I have to keep the formatting of the excel worksheet (e.g. cell border, cell colour)