Studio X 20.10.12 - Excel search bar not visible by robot

Help StudioX
,
1

Hello Everyone,
I currently have access to Studio X 20.10.12 in my company and I’m trying to create a robot to automate a small process.
I have an issue with the “Type Into” activity. I want the robot to filter a column in a PIVOT table by typing in the correct text and clicking OK.
Sometimes the robot see’s the search bar as a separate area and everything works but sometimes the robot doesn’t see the search bar as a separate area and it won’t type in the text. A few days ago it didn’t work and now it’s working again. I played around with the excel packages. I changed the package to an older one and it didn’t work but now when I changed it back to the newest excel package available (2.22.4) and waited a few days it works again.

Is there anything that I can try so that the robot see’s the search bar every time? or is this just a case of having access to a newer version of Studio X which I don’t have?

Thanks in advance for your answers

2

Hi yes
You can add this activity in check app state and add a flag if robot is able to see search bar
Further type activity u can have it sindur flag true condition

You can add retry scope also if u directly want to attempt retry

You can add activate window and then add isme delay between before you type into activity

Hope this help !
@Jakub_Patynski

3

@Jakub_Patynski

first thing on excel it si nt good to do ui automation as it would be unstable

also for pivot filtering if you have updated package then can see pivot related activities as well

but yes upgrading to a latest version would be the first best option

cheers