Are you trying to test something in Excel or use it for data storage? What exactly needs to happen here?
Test Scenario is to do the automation testing on excel smartview, at some point I also need to feed this created excel wtih SmartView with another ecel to feed the data. So here are the steps:
1) Create Excel having SmartView: I created with excelObject = getActiveXObject("Excel.Application"); and some more code to save it at my c:// temp.
2) SmartView is a feature to make the connection to the database to query & view the result direct into the Excel without actually seeing it into the database side.
3) I'm able to create and save it at my C:// temp drive, but I need the code to retrieve it from temp location and bring it on the foreground to do the click actions into the excel to make the commention of database.
So need support on: Code to retrieve the excel from C:// temp location and bring it on the foreground, so TestComplete ObjectSpy can spy the objects in my Excel for connection.
Here are instructions for opening an Excel file, using it for reading and writing data, and saving it. There are code examples for each.
I've already done enough research online & TestComplete website before posted my question in this platform. So the provided link, I know doesn't have the answer of my issue!
Please if there is some expert who really knows, kindly reply on my issue!
Thanks in advance.
