How to neglect a particular row in excel

Hello Guys,

I have a excel input sheet. In that excel sheet A1 row is the header row. I used read range activity to read from A1 row but I have to exclude A2 row And start processing from A3 line items. How can I do it? Is there any way?

Thanks in Advance:)

Hi @mohamedalthaf

You can Insert/Delete Rows activity

Regards
Gokul

1 Like

Hi

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

Or

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

Hi @mohamedalthaf

please refer to xaml below for skipping the first row!

Remove_row.xaml (5.4 KB)

Regards

1 Like

Hi @mohamedalthaf

Refer to the thread

Regards
Gokul

1 Like

Thanks Gokul. I will try n let know

1 Like

Thanks. I will try this and let you know

1 Like

Remove Data Row Activity Perfectly working for my scenario. Thank You

1 Like

Glad it got resolved
@mohamedalthaf

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.