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:)
You can Insert/Delete Rows activity
Hope the below steps would help you resolve this
Let’s take like you have the datatable read and named as dt
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
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
UiPath Activities are the building blocks of automation projects. They enable you to perform all sort of actions ranging from reading PDF, Excel, or Word documents and working with databases or terminals, to sending HTTP requests and monitoring user...
please refer to xaml below for skipping the first row!
Remove_row.xaml (5.4 KB)
Thanks Gokul. I will try n let know
Thanks. I will try this and let you know
Remove Data Row Activity Perfectly working for my scenario. Thank You
Glad it got resolved
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.