Hello! I am new to UiPath and I am currently trying to filter out supplier contact information data in an excel sheet by separating the rows with “Yes” in the 11th column from the rows without it. I am unsure about how to add the rows that meet and don’t meet the conditions into their respective excel docs (“validated Supplier Contact Info.xlsx” and “Invalid Supplier Contact Info.xlsx”)
This is what I tried to do but it does not work.
Also, I tried SupplierContact.Rows.IndexOf(rowIndex).ToString but it returns an error.
Sorry for the long post, and I would appreciate the help