I have an Excel file that I’m looking to copy the values from one sheet to another based on the data between rows.
I started off by reading the Range of the Excel file and then creating a condition IF statement. But this is where I’m not entirely sure what would go next. My IF statement is: dt.Rows.ToString = “Header1”, Then Read Row. But I’m not sure how I would read the rows up until the next header labeled Header2.
I’ve attached a sample Excel document that shows what I’m trying to do.
Welcome to UiPath Community header.zip (15.9 KB)
here you go buddy @jcurry500
hope the below xaml that could help you
Kindly correct me if i have understood the query wrongly