Unable to get UFT to recognize an Excel pop-up from a link
I have been trying to get an Excel sheet pop-up recorded with no success.
There is a link that is clicked (recorded successfully), then a pop-up that has to be clicked to open the file (recorded successfully); and then the Excel sheet materializes on the page. However, UFT does not recognize that the sheet is there. Therefore it cannot be closed. All I need to is for this sheet to be recognized so that it can be closed.
The sequence should be:
Click the link. ....(Good on this.)
Open the file. ....(Good on this)
Excel sheet pops-up; close the Excel sheet. ...( Failing here.)
I have tried all I could find that might be relevent from the HP knowledgebase; and other online solutions to no avail. Can anyone help with this?.
A brilliant trick when automation of the graphical components on the screen does not work, is to manipulate and automate the keyboard! 🙂
In your scenario, the classical Windows command "Alt+F4" should help you close the Excel sheet - hopefully!.
There are a couple of solutions to do this: TYPE, SendKeys and Device Replay.
See this for more information on the three different types: 3 ways to use keyboard input in QuickTest Professional: Type, SendKeys and Device Replay.
How is this Excel window identified? Is UFT able to recognize this window or not?
Do you see a Excel process when this screen is up? If yes, you can try to close the excel process by using the SystemUtil.CloseProcessByName method.
UFT does not recognize that the window is there ...at all in Default mode. Yesterday, I was able to get it to "see" the window by recording that window using the Low-Level recording option. However, that is not optimal; as Low-level recording is very environment specific. (This test will have to execute in the Integration, QA, and prod environments.)
Looks to me like a specialized control.
Talk to your developers to know more about it. If it's a browser control, then you can register it and check if UFT recognizes it.