You can use filter data table activity with rows keep/remove options.
Read the excel using read range activity
Then filter the output datatable using filter datatable activity
Finally you can write the output to a new excel sheet using write range activity
without filer data table activity use add data column in data table then insert into excel . switch activity using this added column in excel then checks condition below
3: If the user age is >40 You need to print or add a data column(Age Band/Status) in the Datatable the guy(Nmae of that person) old.
Welcome to UiPath Community. Please find the attached workflow and Excel sheet with provided columns, which will add new column “Age Band” and remove existing column “Age”.
Here sheet1 is Input and sheet2 is Output. Excel_ColumnAdd.xlsx (11.3 KB) Excel_AddColumn.xaml (10.9 KB)
Please let me know in case any further help required.
Happy Automation