1

I would like to know if it's possible to access an opened Excel (opened by web application during the test and not saved to the PC yet) in test runtime, using java-selenium.

I know that Apache POI is useful with Excel but I don't want to save the Excel doc, only check values...

I'm looking for something similar to this and it should work for UFT frameworks.

Set xlApp = GetObject(, "Excel.Application")
2

Selenium can only control your browser. It cannot control Excel tool. If you somehow manage to open excel spreadsheet from your web page, you will probably be able to control your Excel tool (including reading the content) using COM technology.

For doing that you would need Java-COM bridge. Check this SO post for details.

However I am not sure this is easier than just saving your spreadsheet and parsing it from your hard drive.

  • thanks a lot for the info Alexey. yes, looks more easy save it (using AutoIt for ex) and then, read it. – Alex Mar 18 '19 at 12:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.