How to neglect a particular row in excel

Help Activities
1

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:)

2

Hi @mohamedalthaf

You can Insert/Delete Rows activity

Regards
Gokul

1 Like
3

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
https://docs.uipath.com/activities/docs/remove-data-row

Cheers @mohamedalthaf

1 Like
4

Hi @mohamedalthaf

please refer to xaml below for skipping the first row!

Remove_row.xaml (5.4 KB)

Regards

1 Like
5

Hi @mohamedalthaf

Refer to the thread

Regards
Gokul

1 Like
6

Thanks Gokul. I will try n let know

1 Like
7

Thanks. I will try this and let you know

1 Like
8

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

1 Like
9

Glad it got resolved
@mohamedalthaf

1 Like
10

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