TestComplete detects the table control itself, but none of the internal row/cell objects are exposed

Hi Know​ . Is this the same application you were having issues with when trying to select items from the combo box? If yes, then it's a WPF application (It's important to mention the technology your application uses). What does the Object Browser show for your control?

I've created a WPF application which has a similar control to yours. Looking at the Object Browser, TestComplete exposes the WPFObject("DataGrid", "", 1) object and all the child objects beneath it. If I look at the Extended properties of WPFObject("DataGrid", "", 1) object, I can retrieve the necessary value from a particular row & column using wValue property, as shown below

Object Browser - Using wValue to retrieve value "Load" from row 3 and column "Function"

If your grid control is not exposing similar objects, try to enable MSAA, in Project -> Properties -> Open Application -> MSAA.

You might already be aware of the below but it took me a while to figure out ...

Additionally, for some tables, it is not always obvious how to retrieve a cell and retrieve the cell data (because of the objects the developer used to create the table). 

Sometimes you can access table data as you would expect (like you would in Excel) using the table.Cell(row,column) function like shown below:

function getRow()
{
  var table = Aliases.MyApp.ATable;

  var numOfRows = table.RowCount;
  var foundRow = -1;
  for(let row = 0; row < numOfRows; row++)
  {
    var cellText = table.Cell(row, 0).Text;
    if(cellText === ItemName)
    {
      foundRow = row;
      break;
    }
  }
  return foundRow;
}

and then sometimes you access table data through an iterator like shown below

function Update_Table_()
{
  // Comment: 
  //   The table contents in the file has a '\n' at the end of each line and instead of the columns being separated
  //    by a comma, the columns are separated by '|' verticle line.  
  var table = Aliases.myApp.ATable;
  
  var items = table.Items;
  var totalRows = items.Count;
  var contentForFile = "";
  
  for(var row = 0 ; row < totalRows; row++)
  {
    var item = items.Item(row);
    var description = item.Description_2.OleValue;
    var stringVal = item.StringValue.OleValue;
    var name = item.Suffix.OleValue;
    var units = item.UnitsName.OleValue;
    
    contentForFile = contentForFile + 
    `${name}|${stringVal}|${units}|${description}\n`;
  }
  
  aqFile.WriteToTextFile("C:\\Temp3\\DescriptionSortAscending.txt", contentForFile, aqFile.ctUTF8, true);
}

Hi Know,

Do any of the exposed controls contain methods that can be used to navigate the grid?  Some grid controls can only be navigated in this way.  I would also recommend using record and replay to create a script that will expose what TestComplete sees as you manually navigate the control.  Sometimes this only comes up with x,y clicks but it's worth a try.  😉


 ... If you find my posts helpful drop me a like! 👍 Be sure to mark or post the solution to help others out and/or to credit the one who helped you. 😎

If you can't find any way to actually access the table object, you can always use the OCR table recognize feature:

function OCR_Table(tableObject, hasHeader = true)
{
  // -- OCRTable Object ---
  // Specify the preferable search area
  var searchPref = spNone;
  // Recognize the table content
  var table = OCR.Recognize(tableObject).DetectTable(searchPref, hasHeader);
  return table;
}

You can find more about this at the following link: TestComplete - Detect Table

Hi all,

I tried all the ways you mentioned but it didn't work

My table belongs to datagrid. And it don't have any object cells. > that's why I cannot retrieve the value as normally