Hi, I want to delete all rows in an Excel table where the column “Status” has the value “complete”.
What I did:
- Read the Excel
- Copy datatable
- For each row in copied datatable delete in original datatable
→ Here I get the error “The given DataRow is not in the current DataRowCollection” - Write down original datatable