Looping through specific Column : How To …

[riccardo]

The following code goes through the whole table, I would like to go only through the cells where the Header has a specific Value. Any Idea how this can be done?

Code: Select all

         foreach (Row rows in repo.Grid.Grid.Rows) {
            foreach(Cell c_cell in rows.Cells)
            {
               Report.Info("Cell "+c_cell.Text);
            }
         }

[Support Team]

Hi!

You can use something similar like the following method to get only cells of specific header:

public static void getCellOfSpecificHeader(string strHeaderName)
{
    IList<Ranorex.Cell> myCellList = repo.Form.yourTable.Find<Ranorex.Cell>(".//cell[@accessiblename~'" + strHeaderName + "']");
                    
    foreach(Cell cell in myCellList )
    {
        if(!cell.IsHeader)
            Report.Info("Cell " + cell.Text);                
    }     
}

Regards,
Peter
Ranorex Support Team

[riccardo]

Probably my description was not quite clear... sorry about that

So the goal I need to reach is to get all the cell values below the header column where the Header Column Value is "XYZ".

[Support Team]

Hi!

This method is exactly what you need. The parameter

string strHeaderName

of the Method is the Headername of your cell. In your example this would be "XYZ".
Call the method in main function like:

getCellOfSpecificHeader("XYZ")

I'm sure this will work for .Net Datagrids.

Regards,
Peter
Ranorex Support Team

[riccardo]

Sorry Peter, my mistake...

Thank you very much, your solution did the Job!