Interaction uipath and Excel

Help Studio
1

Hello everyone!
I have an issue

I want to extract data from an Excel file.
This Excel file is filled from a data base via a pluging.

Before extracting the data, i have to filter on month and year and update to have the recent data (otherwise it displays only old data or data i don’t need).
But the robot can’t interact with the dropdown list of the month and year.
image

I tried click, select item, cv click… but i have this message
image

Do you know which activity i can use to select the items or what i can do to extract all the data and filter after?

Thank you for your help
@ppr
@Muhammad_Abdul_Basee
@kawalkarhemant

2

Hi @Laetitia
to filter the excel u can use filter datatable activity
https://docs.uipath.com/activities/docs/filter-data-table

Regards,

Nived N

Happy Automation

1 Like
3

Hi @Laetitia ,

just to add on what @NIVED_NAMBIAR has suggested,

If you can manually type in that cell that has the drop down, you can also use Write cell activity to enter the required parameters. Once you have appropriate data, you can use Filter dataTable activity

2 Likes
4

cv click is for centervision click.
Click with essential click activity

5

Thanks for your help.
But it’s not working either.

6

Thanks for your help, but i can’t manually type into the cell that has the drop down.