Error in Send Hotkey

Help Activities
,
1

I’m trying to filter values in a column in an excel workbook. First, I set up one filter (screen below), everything works.

image
image801×573 20.7 KB

When the robot performs a similar action, it breaks. It is not clear what is the matter, since the actions are similar
image

3

The selector is not correct. Also, why are you trying to filter in Excel?

4

I use the action repeatedly, the first time for one column it works, for the other column it doesn’t. Use activity “filter data table” is not suitable for this task

5

Why not? Why are you trying to filter in Excel?

Again, the error indicates that the selector is not correct or the UI Element does not exist. Use UI Explorer to fix the selector. Pay attention to whether the selector changes each time - this is not uncommon.

6

can you try with click activity in the h1 cell, then use the hotkey
regards

7

Hey @yulya ,

Just wanted to check what use case you are trying to achieve here. Is it to have a filtered data table to add to a different sheet or to an email or what is the intention?

Thanks,
Raluca

8

@yulya, I think is due to that a “windows” is opened when you click to filter. Is your selector in the the range of the windows displayed to filter? Try to check this!

9

@yulya I guess UI interaction for excel automation will not give good results. Can you explain what are you trying to achieve

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.