HOW TO filter the data in the excel sheet

Help Studio
1

TEST.zip (11.8 KB)

i want to filter some excel data,and write these filter datas to the excel another sheet.how to achieve it.ask for someone help.

2

@chlosh, there different ways to do this, you can use the read range activity to read your excel data into data table and then use filter datatable activity to filter out the data and then the output data from that can be parsed into the write range activity to write into the new sheet. in the file you shared, what data do you need to filter for?

3

@chlosh - you can try -

  • read excel using read range
  • filter datatable using dt.select(“columnname=filtertext”)
  • write filter data to excel…
1 Like
4

i wanto filter the row(“due date”) is overdue 60days and 180dyas from now. for example

if row(“due date”)= 05/06/2019 and today is 05/06/2020 ,so it is overdue 365 days.

i want to filter all the rows,and if row(“due date”) is overdue 60days ,then write to the “>60days” sheet.output_test.zip (39.7 KB)

5

hi,i am a uipath newcomer,so could you modify my uploadfile to show me how to do it?thanks you very much.

6

HI @chlosh,

Check this thread.

Regards
Balamurugan.S

7

thanks for your help, but it is different from my example.If you can modify my upload file and show me .it would be great.