How to neglect a particular row in excel


Hope the below steps would help you resolve this

  1. Let’s take like you have the datatable read and named as dt

  2. Now there are two scenarios

If you want to have the first row after header but should process that means
Use a FOR EACH ROW activity and pass dt as input
Inside the loop use a IF condition like this

NOT dt.Rows.IndexOf(CurrentRow).Equals(0)

IF TRUE means it goes to THEN block and inside that have all the activities to process all the rows except first row


There is another scenario where you don’t want that first row itself after headers means

Use a REMOVE DATAROW activity where mention the datatable as dt and rowindex as 0

Cheers @mohamedalthaf

1 Like