Is it even possible to Automate Excel tasks, using click, type into, etc?
I have Excel application score, in which I have added someClick and Type Into activities. Mainly, I want to
- Click “INSERT” from the top ribbon
- Click “Create Pivot Table”
- Type Table name in the textbox in the popup window
- Click “New Sheet”
- Click “OK”
There will be more tasks to automate, but I am already stuck with these simple tasks!
When I use Click or Type Into, and select element on Excel sheet, it looks fine. When I check the selector, it says “Validated” in green, and when I test run, it works fine!
However, if I close the Excel, and re-run the program, it won’t work anymore. None of the clicks and type intos work! When I check the selectors, they are all Invalid! It has a X mark on red backcolor.
Is this even possible at all? And I am only using my temporary Excel file. Eventually, this will go to our customer’s location, with a different Excel file. I thought it would be as simple as just changing the selector’s “title” attribute.
But it won’t even run on my local environment… Any idea on how to make Clicks, Type Intos, work on Excel? and closing and reopening the file won’t affect it?