Forum Discussion

JackSparrow's avatar
JackSparrow
Frequent Contributor
8 years ago
Solved

Extracting the data from Grid-table(Windows Application) using Python

Actually I need to get total values of a single column present in the Grid Table .So first i used the below code for getting the count of Child Items and Names of it which are in  the Grid Table. de...
automation
Desktop Application
Python
TestComplete
  • JackSparrow's avatar
    JackSparrow
    8 years ago

    Hi Colin_McCrae HKosova how are you :)

     

    I got a solution for getting all the list values i.e.

     

    1. First We need click on the list so that drop down of list is visible.
    2. Now Spy the DropDown By **bleep**+CTRL+A
    3. Now Object Spy will show all the Properties.
    4. Go Inside Grid View from there View Details From there to Record.
    5. Now In the Record Give Param as 0 and go inside it .
    6. Check the Display Text Now given the Param as 0
    7. Now you will able to see the First value in the list
    8. So by changing every time the Param of Record and by default keeping the Display Text Value as 0 we will get all the values in the List.

    So the Aliasis Looks like this Aliases.Teachers_debug.TcxComboBoxPopupWindow.TcxExtLookupGrid.TcxGridSite.GridView.ViewData.Records[i].DisplayTexts[0]

     

    Finaly one thing solved :D  but not still the Grid View :P

     

  • JackSparrow's avatar
    JackSparrow
    8 years ago

    Hi Colin_McCrae and HKosova

     

    I was able to read the Grid values ,in the same way which i did in my previous post of how i was able to read all the list values , so finally it solved . Am happy that i was able to solve it myself. :manhappy::smileyvery-happy:

     

    Thanks for your support team

Colin_McCrae's avatar
Colin_McCrae
Community Hero

Hang on .... I'm lost now! :smileylol:

 

So, you can now get a correct item count for the listbox (20), but you can't find the list of items anywhere?

 

Is that right? That's where we're at?

 

For the three types of dropdown/listbox controls I have handlers built for, to get the item text, I use either:

 

wItem(<NUMBER>) - for non-DB linked ones.

ListSource.DataSet.Fields.Fields(<NUMBER>).DisplayText - this a DB linked type.

 

And the third one ..... I have to submit a SQL query for. It does not store the full list anywhere in the properties of the ListBox!

 

So for me, wItem only works on standard, non-DB linked, types.

JackSparrow's avatar
JackSparrow
Frequent Contributor
8 years ago

Hi Colin_McCrae HKosova how are you :)

 

I got a solution for getting all the list values i.e.

 

  1. First We need click on the list so that drop down of list is visible.
  2. Now Spy the DropDown By **bleep**+CTRL+A
  3. Now Object Spy will show all the Properties.
  4. Go Inside Grid View from there View Details From there to Record.
  5. Now In the Record Give Param as 0 and go inside it .
  6. Check the Display Text Now given the Param as 0
  7. Now you will able to see the First value in the list
  8. So by changing every time the Param of Record and by default keeping the Display Text Value as 0 we will get all the values in the List.

So the Aliasis Looks like this Aliases.Teachers_debug.TcxComboBoxPopupWindow.TcxExtLookupGrid.TcxGridSite.GridView.ViewData.Records[i].DisplayTexts[0]

 

Finaly one thing solved :D  but not still the Grid View :P