Forum Discussion

bhaushedbale's avatar
bhaushedbale
Occasional Contributor
9 years ago

Excel child objects identification through Test complete

Hi Team,

 

We have excel sheet and need to verify its different properties through  Test complete Automation tool.

 

e.g :- In excel we have one table whose size will change after some process, need to verify this functionality.

 

Here through Test Complete we are unable to capture all objects, whole grid is coming as one object but data inside grid is not populating as child object.

 

Please let us know how to find the child object or if you have sample code for same then let us know.

 

Regards

2 Replies

Sort By
  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    9 years ago

    Hi Bhaushedbale,

     

    There are several ways of how you can work with Excel to obtain data. All of them are listed in the following article:

    http://smartbear.com/viewarticle/74555/

     

    Please investigate available approaches to identify the one that will match your needs.

    • bhaushedbale's avatar
      bhaushedbale
      Occasional Contributor
      9 years ago

      Hi Tanya,

       

      Thank you for reply.

       

      My requirement is little bit difficult. I dont want to read data from only cells but need some more activity on it.

       

      e.g:- We have on eAutosize button in excel sheet, on click of Autosize button  Table size need to change and as well as Graph has to update. To verify this we were trying to capture Objects of Grid childs, but currently Grid is only populating as as Object, and child objects not able to find.

       

      Please provide us your valueble inputs and information.

       

      Regards

      Bhau