question

Accessing Cell Values by Header Names

If you're trying to use the header names to access the value of a specific cell in the table, the new Table API lets you do that directly:

//Getting the value
double value = Table("GlobalTable1")["Product3"]["ColumnName"];

//Setting the value
Table("GlobalTable1")["Product3"]["ColumnName"] = 5;

//The Table("TableName") constructor was added in 17.1, so in 17.0 you'd do this:
Table table = reftable("GlobalTable1");
double value = table["Product3"]["ColumnName"];

- Note that this method is slower than using a row number since it loops through every row until it finds one with the matching name.

Accessing Cell by Header Names (Node tables only) (17.1 and later)

For a node table, you can also use the header names to access the node corresponding to a specific cell of the table

Table("GlobalTable1").cell("Product3","ColumnName")

You can then find the rank of this node or its parent to get the column and row number

treenode cell = Table("GlobalTable1").cell("Product3","ColumnName");
int columnNumber = cell.rank;
int rowNumber = cell.up.rank;

Loop with getRowHeader method

You can also just loop through rows until you find the header:

string rowName = "Row 2";
Table table = Table("GlobalTable1");    	//reftable("GlobalTable1") in 17.0
for(int i = 1; i <= table.numRows; i++) {
	if(table.getRowHeader(i) == rowName)
		return i;
}