Forum Discussion

bhaushedbale's avatar
bhaushedbale
Occasional Contributor
10 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

    • bhaushedbale's avatar
      bhaushedbale
      Occasional Contributor
      10 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