Excel solution

1: read an excel file with 10 sample rows

2: The excel file should contain Name , Email , Age, Address

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

4: Write that excel in other file and delete the age column

@Jaya_Prakash,
Welcome to UiPath community

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.

@Jaya_Prakash,

Have you implemented something like you have mentioned or still looking for help?

looking for help am struct in 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

@Jaya_Prakash,

You can use ‘For Each Row’ activity on datatable or You can use “Select” statement on datatable and get the desired values.

Please refer this:

u tried this one

Hi @Jaya_Prakash ,

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

If you don’t want to use filter data table activity then use below assign activity:
OutDT = DT.Select("[Age] > 40").CopyToDataTable

Please find attached workflow for the same.Excel_AddColumn.xaml (11.8 KB)