DotNetTableFunctions

Last Updated:

Actions for working with DotNetTable objects


[How To Read This Reference]
ActivateCell
RJ
Attempts to perform a double click on a DotNetTable cell.
ActivateColumnLabel
RJ
Double clicks on the label of the specified column.
AssignCellContainsTextRow
RJ
Assigns a user-defined variable a row # based on partial matching cell values.
AssignCellTextRow
RJ
Assigns a user-defined variable a row # based on matching cell values.
AssignVariableCellText
RJ
Attempts to extract a particular cell value and assign it to the provided variable name.
AssignVariableFuzzyCellText
RJ
Attempts to extract a particular cell value and assign it to the provided variable name.
CaptureFuzzyRangeToFile
RJ
Saves a range of values to the specified file.
CaptureRangeToFile
RJ
Saves a range of values to the specified file.
ClickCell
RJ
Attempts to perform a Click on a cell in a DotNetTable.
ClickColumnLabel
RJ
Clicks on the label of the specified column.
DoubleClickCell
RJ
Attempts to perform a double click on a cell in a DotNetTable.
DoubleClickColumnLabel
RJ
Double clicks on the label of the specified column.
RightClickCell
RJ
Attempts to perform a right click on a cell in a DotNetTable.
SelectCell
RJ
Same as ClickCell.
SelectCellContainsTextFind
RJ
Attempts to select a particular cell by finding the row based on cell values.
SelectCellText
RJ
Attempts to select a particular cell.
SelectCellTextFind
RJ
Attempts to select a particular cell by finding the row based on cell values.
SelectCellTextSpecial
RJ
Holds down either Ctrl or Shift while making a cell selection with emulating either a Left or Right mouse click.
SelectFuzzyCellText
RJ
Attempts to select a particular cell.
SelectFuzzyCellTextFind
RJ
Attempts to select a particular cell by finding the row based on fuzzy cell values.
VerifyCellEditable
RJ
Verifies whether the specified cell is editable.
VerifyCellText
RJ
Attempts to verify a particular cell value.
VerifyCellTextContains
RJ
Attempts to verify a particular cell value.
VerifyCellTextFind
RJ
Attempts to verify a particular cell by finding the row based on cell values.
VerifyColumnLabel
RJ
Attempts to verify a particular column's label when given a column number.
VerifyFuzzyCellText
RJ
Attempts to verify a particular cell value.
VerifyFuzzyCellTextContains
RJ
Attempts to verify a particular cell value.
VerifyFuzzyCellTextFind
RJ
Attempts to verify a particular cell by finding the row based on fuzzy cell values.

DotNetTableFunctions::ActivateCell
RJ

Attempts to perform a double click on a DotNetTable cell.

Clicks on a particular row/column of the table. The default location is Row=1, Col=1 unless either parameter is specified otherwise.

Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row in the row/col specification.


  2. [ Col = 1 ]
    The 1-based cell column in the row/col specification.


Examples:
  • T, DotNetWin, DotNetTable, ActivateCell
    Click the cell at row,col cell 1,1.


  • T, DotNetWin, DotNetTable, ActivateCell, 3, 4
    Click the cell at row,col cell 3,4.


[How To Read This Reference]

DotNetTableFunctions::ActivateColumnLabel
RJ

Double clicks on the label of the specified column.

Performs a double click on the specified column number. A Y offset will be able to be set in the future.

Fields: [ ]=Optional with Default Value
  1. ColNumber
    The 1-based column label number to double click.


  2. [ YOffset = ]
    (FUTURE) Number of pixels to adjust where the actual double click occurs.


Examples:
  • T, DotNetWin, DotNetTable, ActivateColumnLabel, "2"
    Performs a double click on the 2nd column label in the table.


[How To Read This Reference]

DotNetTableFunctions::AssignCellContainsTextRow
RJ

Assigns a user-defined variable a row # based on partial matching cell values.

The cell value from the specified column in the found row is also assigned to a variable derived from the user-defined variable name.

The cell value comparisons are not case-senstive, and provided values can be substrings of the actual cell value in the table.



Fields: [ ]=Optional with Default Value
  1. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string. This variable also is the rootname for the variable that will receive the cell text value once the row # is identified. The cell value variable will be the user-defined variable +".Value".

  2. Col
    The 1-based cell column # or header value, identifying the column for extracting the cell value into variable +".Value".

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

    The field header comparisons are not case-senstive, and provided values can be substrings of the actual header value in the table.



  3. ColN
    A 1-based cell column #, or header value, identifying the column to locate the VALUEN below.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

    The field header comparisons are not case-senstive, and provided values can be substrings of the actual header value in the table.



  4. ValueN
    A Value to search for in the 'COLN' column.

    These values can be partial substrings and are not case-sensitive.

Examples:
  • T, DotNetWin, DotNetTable, AssignCellContainsTextRow, Variable, "Date","Time", "09:58 AM", "Change","Change #2","Revision", "2"
    Assigns the variable "Variable" the first row # satisfying the matching colN/valueN values.

    Also assigns variable "Variable.Value" the cell value found in the "Date" column at the matching row.

[How To Read This Reference]

DotNetTableFunctions::AssignCellTextRow
RJ

Assigns a user-defined variable a row # based on matching cell values.

The cell value from the specified column in the found row is also assigned to a variable derived from the user-defined variable name.

Fields: [ ]=Optional with Default Value
  1. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string. This variable also is the rootname for the variable that will receive the cell text value once the row # is identified. The cell value variable will be this user-defined variable +".Value".

  2. Col
    The 1-based cell column # or header value, identifying the column for extracting the cell value into variable +".Value".

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

  3. ColN
    A 1-based cell column #, or header value, identifying the column to locate the VALUEN below.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

  4. ValueN
    A Value to search for in the 'COLN' column

    These values are case-sensitive and must consititute an exact match.

Examples:
  • T, DotNetWin, DotNetTable, AssignCellTextRow, Variable, "Date","Time", "09:58 AM", "Change","Change #2","Revision", "2"
    Assigns the variable "Variable" the first row # satisfying the matching colN/valueN values.

    Also assigns variable "Variable.Value" the cell value found in the "Date" column at the matching row.

[How To Read This Reference]

DotNetTableFunctions::AssignVariableCellText
RJ

Attempts to extract a particular cell value and assign it to the provided variable name.

Note, if you supply the name of the variable and include the leading caret (^) symbol then the variable must be enclosed in quotes. Otherwise, that variable will be used like any other variable and the substituted value of that variable will be interpretted as the name of the variable you wish to use.

Fields: [ ]=Optional with Default Value
  1. VariableName
    The name of the variable to receive the property value.

    The name of the variable to receive the property value. Note, if you supply the name of the variable and include the leading caret (^) symbol then the variable must be enclosed in quotes. Otherwise, that variable will be used like any other variable and the substituted value of that variable will be interpretted as the name of the variable you wish to use.

  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

Examples:
  • T, DotNetWin, DotNetTable, AssignVariableCellText, AVariableName
    Assign the value of cell 1,1 in DotNetTable to DDVariable ^AVariableName.


  • T, DotNetWin, DotNetTable, AssignVariableCellText, "AVariableName", 1 , 1
    Assign the value of cell 1,1 in DotNetTable to DDVariable ^AVariableName.


  • T, DotNetWin, DotNetTable, AssignVariableCellText, "^AVariableName", 4, "Field5"
    Assign the value of cell 4, Field5 in DotNetTable to DDVariable ^AVariableName.

    The column is determined by matching the text "Field5" to the field headers in the DotNetTable.

  • C, SetVariableValues, ^AVariableName="NextVariableName"
    T, DotNetWin, DotNetTable, AssignVariableCellText, ^AVariableName, "ADatum", 5
    Assign the value of cell ADatum,5 in DotNetTable to DDVariable ^NextVariableName.

    The row is determined by matching the text "ADatum" to the first cell in column 1 in the DotNetTable that contains "ADatum".

[How To Read This Reference]

DotNetTableFunctions::AssignVariableFuzzyCellText
RJ

Attempts to extract a particular cell value and assign it to the provided variable name.

"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.

Fields: [ ]=Optional with Default Value
  1. VariableName
    The name of the variable to receive the property value.

    The name of the variable to receive the property value. Note, if you supply the name of the variable and include the leading caret (^) symbol then the variable must be enclosed in quotes. Otherwise, that variable will be used like any other variable and the substituted value of that variable will be interpretted as the name of the variable you wish to use.

  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number. This command allows for case-insensitive substring matches for row text when used in place of an actual row index.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This command allows for case-insensitive substring matches for header text when used in place of an actual column index.

Examples:
  • T, DotNetWin, DotNetTable, AssignVariableFuzzyCellText, AVariableName
    Assign the value of cell 1,1 in DotNetTable to DDVariable ^AVariableName.


  • T, DotNetWin, DotNetTable, AssignVariableFuzzyCellText, "AVariableName", 1 , 1
    Assign the value of cell 1,1 in DotNetTable to DDVariable ^AVariableName.


  • T, DotNetWin, DotNetTable, AssignVariableFuzzyCellText, "^AVariableName", 4, "field5"
    Assign the value of cell 4, "Field5" in DotNetTable to DDVariable ^AVariableName.

    The column is determined by case-insensitive comparing the text "field5" to the field headers in the DotNetTable.

  • C, SetVariableValues, ^AVariableName="NextVariableName"
    T, DotNetWin, DotNetTable, AssignVariableFuzzyCellText, ^AVariableName, "datum", 5
    Assign the value of cell ADatum,Field5 in DotNetTable to DDVariable ^NextVariableName.

    The row is determined by seeking the first cell in column 1 in the DotNetTable that contains substring "datum". The "5" also shows up as a substring match to the column header "Field5". So be cautious, here.

[How To Read This Reference]

DotNetTableFunctions::CaptureFuzzyRangeToFile
RJ

Saves a range of values to the specified file.

"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.

Fields: [ ]=Optional with Default Value
  1. FileName
    The name of the file to receive the data.

    The data will be output as TAB delimited values. The filename is usually just the short filename.ext and as such will be stored in the project's Datapool\Test directory.
    If you specify a relative path, the path is relative to the project's root directory. "Datapool" is a subdirectory of that root directory.
    Any specified full or relative path must already exist.

  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number. This command allows for case-insensitive substring matches for row text when used in place of an actual row index.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This command allows for case-insensitive substring matches for header text when used in place of an actual column index.

  4. [ Rows = ]
    The number of rows to capture.

    If there are not enough rows to satisfy the request then we will obviously only capture up to the last available row.
    If the parameter is not provided, all subsequent rows from the specified starting row are captured.

  5. [ Columns = ]
    The number of columns to capture.

    If there are not enough columns to satisfy the request then we will obviously only capture up to the last available column.
    If the parameter is not provided, all subsequent columns from the specified starting column are captured.

  6. [ FileEncoding = ]
    Specify a character encoding to be used when saving data to a file. If it is not specified, the system default file encoding will be used. The encoding should be a valid string supported by Java; if it is not valid, the system default file encoding will be used instead.


  7. [ FilterMode = ]
    (FUTURE) A file filter to use when processing the text values.


  8. [ FilterOptions = ]
    (FUTURE) Filter options to use with the file filter.


Examples:
  • T, DotNetWin, DotNetTable, CaptureFuzzyRangeToFile, AFileName.txt
    Saves the entire table into <project>\Datapool\Test\AFileName.txt


  • T, DotNetWin, DotNetTable, CaptureFuzzyRangeToFile, AFileName.txt, 1 , 1
    Saves the entire table into <project>\Datapool\Test\AFileName.txt


  • T, DotNetWin, DotNetTable, CaptureFuzzyRangeToFile, AFileName.txt, 4, "field5", 2, 5
    Saves a 2 rows by 5 columns range of cells starting at cell 4, Field5.

    The starting column is determined by fuzzy matching the text "field5" to the field headers in the DotNetTable. The captured table values are saved into <project>\Datapool\Test\AFileName.txt

  • T, DotNetWin, DotNetTable, CaptureFuzzyRangeToFile, AFileName.txt, "datum", 5, , 2
    Saves a range of all remaining rows by 2 columns wide starting at cell "ADatum", "Field5".

    The starting row is determined by seeking the first cell in column 1 in the DotNetTable that contains substring "datum". The "5" also shows up as a substring match to the column header "Field5". So be cautious, here. No ROWS parameter was provided. Thus, all subsequest rows from the 2 columns are captured. The values are saved into <project>\Datapool\Test\AFileName.txt

  • T, DotNetWin, DotNetTable, CaptureFuzzyRangeToFile, AFileName.txt, , , , , "UTF-8"
    Saves the entire table into <project>\Datapool\Test\AFileName.txt

    Saves the entire table into <project>\Datapool\Test\AFileName.txt
    Writing file with "UTF-8" encoding.

[How To Read This Reference]

DotNetTableFunctions::CaptureRangeToFile
RJ

Saves a range of values to the specified file.


Fields: [ ]=Optional with Default Value
  1. FileName
    The name of the file to receive the data.

    The data will be output as TAB delimited values. The filename is usually just the short filename.ext and as such will be stored in the project's Datapool\Test directory.
    If you specify a relative path, the path is relative to the project's root directory. "Datapool" is a subdirectory of that root directory.
    Any specified full or relative path must already exist.

  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

  4. [ Rows = ]
    The number of rows to capture.

    If there are not enough rows to satisfy the request then we will obviously only capture up to the last available row.
    If the parameter is not provided, all subsequent rows from the specified starting row are captured.

  5. [ Columns = ]
    The number of columns to capture.

    If there are not enough columns to satisfy the request then we will obviously only capture up to the last available column.
    If the parameter is not provided, all subsequent columns from the specified starting column are captured.

  6. [ FileEncoding = ]
    Specify a character encoding to be used when saving data to a file. If it is not specified, the system default file encoding will be used. The encoding should be a valid string supported by Java; if it is not valid, the system default file encoding will be used instead.


  7. [ FilterMode = ]
    (FUTURE) A file filter to use when processing the text values.


  8. [ FilterOptions = ]
    (FUTURE) Filter options to use with the file filter.


Examples:
  • T, DotNetWin, DotNetTable, CaptureRangeToFile, AFileName.txt
    Saves the entire table into >project>\Datapool\Test\AFileName.txt


  • T, DotNetWin, DotNetTable, CaptureRangeToFile, AFileName.txt, 1 , 1
    Saves the entire table into <project>\Datapool\Test\AFileName.txt


  • T, DotNetWin, DotNetTable, CaptureRangeToFile, AFileName.txt, 4, "Field5", 2, 5
    Saves a 2 rows by 5 columns range of cells starting at cell 4, Field5.

    The starting column is determined by matching the text "Field5" to the field headers in the DotNetTable. The values are saved into <project>\Datapool\Test\AFileName.txt

  • T, DotNetWin, DotNetTable, CaptureRangeToFile, AFileName.txt, "ADatum", 5, , 2
    Saves a range of all remaining rows by 2 columns wide starting at cell "ADatum", 5.

    The starting row is determined by matching the text "ADatum" to the first cell in column 1 in the DotNetTable that contains "ADatum". Since no ROWS parameter was provided, all subsequest rows from the 2 columns are captured. The values are saved into <project>\Datapool\Test\AFileName.txt

  • T, DotNetWin, DotNetTable, CaptureRangeToFile, AFileName.txt, , , , , "UTF-8"
    Saves the entire table into >project>\Datapool\Test\AFileName.txt

    Saves the entire table into >project>\Datapool\Test\AFileName.txt
    Writing file with "UTF-8" encoding.

[How To Read This Reference]

DotNetTableFunctions::ClickCell
RJ

Attempts to perform a Click on a cell in a DotNetTable.

Clicks on a particular row/column of the table. The default location is Row=1, Col=1 unless either parameter is specified otherwise.

Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row in the row/col specification.


  2. [ Col = 1 ]
    The 1-based cell column in the row/col specification.


Examples:
  • T, DotNetWin, DotNetTable, CLICKCELL
    Click the cell at row,col cell 1,1.


  • T, DotNetWin, DotNetTable, CLICKCELL, 3, 4
    Click the cell at row,col cell 3,4.


[How To Read This Reference]

DotNetTableFunctions::ClickColumnLabel
RJ

Clicks on the label of the specified column.

Performs a single click on the specified column number. A Y offset will be able to be set in the future.

Fields: [ ]=Optional with Default Value
  1. ColNumber
    The 1-based column label number to click.


  2. [ YOffset = ]
    (FUTURE) Number of pixels to adjust where the actual click occurs.


Examples:
  • T, DotNetWin, DotNetTable, ClickColumnLabel, "2"
    Performs a single click on the 2nd column label in the table.


[How To Read This Reference]

DotNetTableFunctions::DoubleClickCell
RJ

Attempts to perform a double click on a cell in a DotNetTable.

Clicks on a particular row/column of the table. The default location is Row=1, Col=1 unless either parameter is specified otherwise.

Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row in the row/col specification.


  2. [ Col = 1 ]
    The 1-based cell column in the row/col specification.


Examples:
  • T, DotNetWin, DotNetTable, DoubleClickCell
    Click the cell at row,col cell 1,1.


  • T, DotNetWin, DotNetTable, DoubleClickCell, 3, 4
    Click the cell at row,col cell 3,4.


[How To Read This Reference]

DotNetTableFunctions::DoubleClickColumnLabel
RJ

Double clicks on the label of the specified column.

Performs a double click on the specified column number. A Y offset will be able to be set in the future.

Fields: [ ]=Optional with Default Value
  1. ColNumber
    The 1-based column label number to double click.


  2. [ YOffset = ]
    (FUTURE) Number of pixels to adjust where the actual double click occurs.


Examples:
  • T, DotNetWin, DotNetTable, DoubleClickColumnLabel, "2"
    Performs a double click on the 2nd column label in the table.


[How To Read This Reference]

DotNetTableFunctions::RightClickCell
RJ

Attempts to perform a right click on a cell in a DotNetTable.

Right clicks on a particular row/column of the table. The default location is Row=1, Col=1 unless either parameter is specified otherwise.

Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row in the row/col specification.


  2. [ Col = 1 ]
    The 1-based cell column in the row/col specification.


Examples:
  • T, DotNetWin, DotNetTable, RightClickCell
    Right click the cell at row,col cell 1,1.


  • T, DotNetWin, DotNetTable, RightClickCell, 3, 4
    Right click the cell at row,col cell 3,4.


[How To Read This Reference]

DotNetTableFunctions::SelectCell
RJ

Same as ClickCell.

Clicks on a particular row/column of the table. The default location is Row=1, Col=1 unless either parameter is specified otherwise.

Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row in the row/col specification.


  2. [ Col = 1 ]
    The 1-based cell column in the row/col specification.


Examples:
  • T, DotNetWin, DotNetTable, SelectCell
    Click the cell at row,col cell 1,1.


  • T, DotNetWin, DotNetTable, SelectCell, 3, 4
    Click the cell at row,col cell 3,4.


[How To Read This Reference]

DotNetTableFunctions::SelectCellContainsTextFind
RJ

Attempts to select a particular cell by finding the row based on cell values.

This is the same as SelectFuzzyCellTextFind.
The row # for the cell is also assigned to a user-defined variable. The parameter values are not case-sensitive, and can be substrings of the actual table values.

Fields: [ ]=Optional with Default Value
  1. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string

  2. Col
    The 1-based cell column # or header value, identifying the column for the select.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

    These comparisons are not case-sensitive and can be substrings of the actual table text.



  3. ColN
    A 1-based cell column #, or header value, identifying the column to locate the VALUEN below.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

    These comparisons are not case-sensitive and can be substrings of the actual table text.



  4. ValueN
    A Value to search for in the 'COLN' column

    The values are not case-sensitive and can be substrings of the actual table text.

Examples:
  • T, DotNetWin, DotNetTable, SelectCellContainsTextFind, Variable, "Date","Time", "09:58 AM", "Change","Change #2","Revision", "2"
    Selects the cell in the first row matching the colN/valueN values.

    Selects the "Date" cell in the row matching the colN/valueN values: "Time"/"09:58 AM", "Change"/"Change #2", "Revision"/"2". The variable 'Variable' will be assigned the matching row number.

    These comparisons are not case-sensitive and can be substrings of the actual table text.



[How To Read This Reference]

DotNetTableFunctions::SelectCellText
RJ

Attempts to select a particular cell.


Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number.

  2. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

Examples:
  • T, DotNetWin, DotNetTable, SelectCellText
    Selects cell 1,1 in DotNetTable.

    Default row and column indices substituted for missing parameters.

  • T, DotNetWin, DotNetTable, SelectCellText, 1 , 1
    Selects cell 1,1 in DotNetTable.


  • T, DotNetWin, DotNetTable, SelectCellText, 4, "Field5"
    Selects cell 4, Field5 in DotNetTable.

    The column is determined by matching the text "Field5" to the field headers in the DotNetTable.

  • T, DotNetWin, DotNetTable, SelectCellText, "ADatum", 5
    Selects cell ADatum,5 in DotNetTable.

    The row is determined by matching the text "ADatum" to the first cell in column 1 in the DotNetTable that contains "ADatum".

[How To Read This Reference]

DotNetTableFunctions::SelectCellTextFind
RJ

Attempts to select a particular cell by finding the row based on cell values.

The row # for the cell is also assigned to a user-defined variable.

Fields: [ ]=Optional with Default Value
  1. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string

  2. Col
    The 1-based cell column # or header value, identifying the column for the select.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

  3. ColN
    A 1-based cell column #, or header value, identifying the column to locate the VALUEN below.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

  4. ValueN
    A Value to search for in the 'COLN' column


Examples:
  • T, DotNetWin, DotNetTable, SelectCellTextFind, Variable, "Date","Time", "09:58 AM", "Change","Change #2","Revision", "2"
    Selects the cell in the first row matching the colN/valueN values.

    Selects the "Date" cell in the row matching the colN/valueN values: "Time"/"09:58 AM", "Change"/"Change #2", "Revision"/"2". The variable 'Variable' will be assigned the matching row number.

[How To Read This Reference]

DotNetTableFunctions::SelectCellTextSpecial
RJ

Holds down either Ctrl or Shift while making a cell selection with emulating either a Left or Right mouse click.

Special cell selection which can be used to select multiple rows.

Fields: [ ]=Optional with Default Value
  1. SpecialKey
    The special key command used in the row selection. For now, ownly Control and Shift are supported.


  2. MouseClick
    The type of mouse click needed. For now, ownly Left and Right are supported.


  3. Row
    The 1-based cell row in the row/col specification.


  4. Col
    The 1-based cell column in the row/col specification.


Examples:
  • T, Frame, custTableTable, SelectCellTextSpecial, Control, Left, 2, 3
    Performs a left click on cell 2,3 while holding down Control.


  • T, Frame, custTableTable, SelectCellTextSpecial, Shift, Left, 2, 3
    Performs a left click on cell 2,3 while holding down Shift.


[How To Read This Reference]

DotNetTableFunctions::SelectFuzzyCellText
RJ

Attempts to select a particular cell.

"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.

Fields: [ ]=Optional with Default Value
  1. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number. This command allows for case-insensitive substring matches for row text when used in place of an actual row index.

  2. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This command allows for case-insensitive substring matches for header text when used in place of an actual column index.

Examples:
  • T, DotNetWin, DotNetTable, SelectFuzzyCellText
    Selects cell 1,1 in DotNetTable.

    Default row and column indices substituted for missing parameters.

  • T, DotNetWin, DotNetTable, SelectFuzzyCellText, 1 , 1
    Selects cell 1,1 in DotNetTable.


  • T, DotNetWin, DotNetTable, SelectFuzzyCellText, 4, "field5"
    Selects cell 4, "Field5" in DotNetTable.

    The column is determined by case-insensitive comparing the text "field5" to the field headers in the DotNetTable.

  • T, DotNetWin, DotNetTable, SelectFuzzyCellText, "datum", 5
    Selects cell ADatum,Field5 in DotNetTable.

    The row is determined by seeking the first cell in column 1 in the DotNetTable that contains substring "datum". The "5" also shows up as a substring match to the column header "Field5". So be cautious, here.

[How To Read This Reference]

DotNetTableFunctions::SelectFuzzyCellTextFind
RJ

Attempts to select a particular cell by finding the row based on fuzzy cell values.

This is the same as SelectCellContainsTextFind.
"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified column/cell text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.

Fields: [ ]=Optional with Default Value
  1. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string

  2. Col
    The 1-based cell column # in the row/col specification or fuzzy column header text.

    The routine will first attempt to fuzzy-match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

  3. ColN
    A 1-based cell column # in the row/col specification or fuzzy column header text.

    The routine will first attempt to fuzzy-match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

  4. ValueN
    A Value to search for in a cell under the 'ColN' column

    A Value to search for in a cell under the 'ColN' column

Examples:
  • T, DotNetWin, DotNetTable, SelectFuzzyCellTextFind, Variable, "Da","Ti", "09:58 AM", "Cha","Change #2","Rev", "2"
    Selects the cell in the row matching the colN/valueN values.

    Selects the "Da" cell in the row fuzzy-matching the colN/valueN values: "Ti"/"09:58 AM", "Cha"/"Change #2", "Rev"/"2". The variable 'Variable' will be assigned the matching row number.

[How To Read This Reference]

DotNetTableFunctions::VerifyCellEditable
RJ

Verifies whether the specified cell is editable.

Invokes the "editCellAt" method on a specific cell. The method returns a boolean which is used for the verification.

Fields: [ ]=Optional with Default Value
  1. Row
    The 1-based cell row in the row/col specification.


  2. Col
    The 1-based cell column in the row/col specification.


  3. ExpectedValue
    The case-insensitive value we expect for the editable value.


Examples:
  • T, DotNetWin, DotNetTable, VerifyCellEditable, "2", "3", "true"
    Verifies that the cell in 2,3 is editable.


[How To Read This Reference]

DotNetTableFunctions::VerifyCellText
RJ

Attempts to verify a particular cell value.


Fields: [ ]=Optional with Default Value
  1. BenchValue
    The case-sensitive expected value for the specified cell.


  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

Examples:
  • T, DotNetWin, DotNetTable, VerifyCellText, FirstCellValue
    Compares the value of cell 1,1 in DotNetTable to bench text "FirstCellValue".

    Default row and column indices substituted for missing parameters.

  • T, DotNetWin, DotNetTable, VerifyCellText, "FirstCellValue", 1 , 1
    Compares the value of cell 1,1 in DotNetTable to bench text "FirstCellValue".


  • T, DotNetWin, DotNetTable, VerifyCellText, "BenchValue", 4, "Field5"
    Compares the value of cell 4, Field5 in DotNetTable to bench text "BenchValue".

    The column is determined by matching the text "Field5" to the field headers in the DotNetTable.

  • T, DotNetWin, DotNetTable, VerifyCellText, "BenchData", "ADatum", 5
    Compares the value of cell ADatum,5 in DotNetTable to bench text "BenchData".

    The row is determined by matching the text "ADatum" to the first cell in column 1 in the DotNetTable that contains "ADatum".

[How To Read This Reference]

DotNetTableFunctions::VerifyCellTextContains
RJ

Attempts to verify a particular cell value.

The value comparison is NOT case-sensitive and can be a substring.

Fields: [ ]=Optional with Default Value
  1. BenchValue
    The expected value for the specified cell.

    The value can be a substring of the full expected value and is NOT case-sensitive.

  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

Examples:
  • T, DotNetWin, DotNetTable, VerifyCellTextContains, FirstCellValue
    Matches the "FirstCellValue" value of cell 1,1 in DotNetTable to bench text "FirstCellValue".

    In this case, they happen to be an exact match. Default row and column indices are used for missing parameters.

  • T, DotNetWin, DotNetTable, VerifyCellTextContains, "firstcell", 1 , 1
    Matches the "FirstCellValue" value of cell 1,1 in DotNetTable to bench text "firstcell".

    "firstcell" is a valid substring match since it is not case-sensitive.

  • T, DotNetWin, DotNetTable, VerifyCellTextContains, "bench", 4, "Field5"
    Matches the "BenchValue" value of cell 4, Field5 in DotNetTable to bench text "bench".

    "bench" is a valid substring match since it is not case-sensitive.
    The column is determined by matching the text "Field5" to the field headers in the DotNetTable.

  • T, DotNetWin, DotNetTable, VerifyCellTextContains, "bench", "ADatum", 5
    Matches the "BenchValue" value of cell ADatum,5 in DotNetTable to bench text "bench".

    "bench" is a valid substring match since it is not case-sensitive.
    The row is determined by matching the text "ADatum" to the first cell in column 1 in the DotNetTable that contains "ADatum".

[How To Read This Reference]

DotNetTableFunctions::VerifyCellTextFind
RJ

Attempts to verify a particular cell by finding the row based on cell values.


Fields: [ ]=Optional with Default Value
  1. BenchValue
    The case-sensitive expected value for the specified cell.


  2. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string

  3. Col
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

  4. ColN
    A 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

  5. ValueN
    A Value to search for in a cell under the 'ColN' column

    A Value to search for in a cell under the 'ColN' column

Examples:
  • T, DotNetWin, DotNetTable, VerifyCellTextFind, "10/09/2003", Variable, "Date","Time", "09:58 AM", "Change","Change #2","Revision", "2"
    Verifies the cell in the row matching the colN/valueN values.

    Verifies the "Date" cell in the row matching the colN/valueN values: "Time"/"09:58 AM", "Change"/"Change #2", "Revision"/"2" is equal "10/09/2003". The variable 'Variable' will be assigned the matching row number.

[How To Read This Reference]

DotNetTableFunctions::VerifyColumnLabel
RJ

Attempts to verify a particular column's label when given a column number.

Verifies a column label when given the column number. It currently does NOT work with columns with multi-line names.

Fields: [ ]=Optional with Default Value
  1. ColLabel
    The case-insensitive expected value for the specified column label.


  2. ColNumber
    The 1-based column number of the label that needs verified.


Examples:
  • T, DotNetWin, DotNetTable, VerifyColumnLabel, "Foo", "4"
    Verifies that the 4th column in the table has the label "Foo".


  • T, DotNetWin, DotNetTable, VerifyColumnLabel, "Foo SecondFoo", "4"
    Verifies that the 4th column in the table has the label "Foo SecondFoo"

    This will verify correctly if the column label is all on one line, but if "Foo" is on one line, and "SecondFoo" is on a separate line, this verification will not work.

[How To Read This Reference]

DotNetTableFunctions::VerifyFuzzyCellText
RJ

Attempts to verify a particular cell value.

"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.
The Benchmark must be exact, however.

Fields: [ ]=Optional with Default Value
  1. BenchValue
    The case-sensitive expected value for the specified cell.


  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number. This command allows for case-insensitive substring matches for row text when used in place of an actual row index.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This command allows for case-insensitive substring matches for header text when used in place of an actual column index.

Examples:
  • T, DotNetWin, DotNetTable, VerifyFuzzyCellText, FirstCellValue
    Compares the value of cell 1,1 in DotNetTable to bench Text "FirstCellValue".

    Default row and column indices substituted for missing parameters.

  • T, DotNetWin, DotNetTable, VerifyFuzzyCellText, "FirstCellValue", 1 , 1
    Compares the value of cell 1,1 in DotNetTable to bench text "FirstCellValue".


  • T, DotNetWin, DotNetTable, VerifyFuzzyCellText, ABenchValue, 4, "field5"
    Compares the value of cell 4, "Field5" in DotNetTable to bench text "ABenchValue".

    The column is determined by case-insensitive comparing the text "field5" to the field headers in the DotNetTable.

  • T, DotNetWin, DotNetTable, VerifyFuzzyCellText, ^ABenchValue, "datum", 5
    Compares the value of cell ADatum,Field5 in DotNetTable to bench text in variable ^ABenchValue.

    The row is determined by seeking the first cell in column 1 in the DotNetTable that contains substring "datum". The "5" also shows up as a substring match to the column header "Field5". So be cautious, here.

[How To Read This Reference]

DotNetTableFunctions::VerifyFuzzyCellTextContains
RJ

Attempts to verify a particular cell value.

"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.
The Benchmark comparison is NOT case-sensitive and can be a substring.

Fields: [ ]=Optional with Default Value
  1. BenchValue
    The expected value for the specified cell.

    The value can be a substring of the full expected value and is NOT case-sensitive.

  2. [ Row = 1 ]
    The 1-based cell row # in the row/col specification or a unique row value in column 1.

    The routine will first attempt to match any provided value with a cell value in column 1. If no match is found, it will expect the value to be a valid 1-based row number. This command allows for case-insensitive substring matches for row text when used in place of an actual row index.

  3. [ Col = 1 ]
    The 1-based cell column # in the row/col specification or column header text.

    The routine will first attempt to match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This command allows for case-insensitive substring matches for header text when used in place of an actual column index.

Examples:
  • T, DotNetWin, DotNetTable, VerifyFuzzyCellTextContains, FirstCellValue
    Matches the "FirstCellValue" value of cell 1,1 in DotNetTable to bench text "FirstCellValue".

    Default row and column indices substituted for missing parameters.
    This also happens to be an exact text match.

  • T, DotNetWin, DotNetTable, VerifyFuzzyCellTextContains, "firstcell", 1 , 1
    Matches the "FirstCellValue" value of cell 1,1 in DotNetTable to bench text "firstcell".

    "firstcell" is a matching substring of the retrieved cell value.

  • T, DotNetWin, DotNetTable, VerifyFuzzyCellTextContains, bench, 4, "field5"
    Matches the "ABenchValue" value of cell 4, "Field5" in DotNetTable to bench text "bench".

    The column is determined by case-insensitive comparing the text "field5" to the field headers in the DotNetTable. "bench" is a matching substring of the retrieved cell value.

  • T, DotNetWin, DotNetTable, VerifyFuzzyCellText, bench, "datum", 5
    Matches the "ABenchValue" value of cell ADatum,Field5 in DotNetTable to bench text "bench".

    The row is determined by seeking the first cell in column 1 in the DotNetTable that contains substring "datum". The "5" also shows up as a substring match to the column header "Field5". So be cautious, here.
    "bench" is a matching substring of the retrieved cell value.

[How To Read This Reference]

DotNetTableFunctions::VerifyFuzzyCellTextFind
RJ

Attempts to verify a particular cell by finding the row based on fuzzy cell values.

"Fuzzy" matches come into play when using header field text or column1 row text to specify row and column identities. The specified column/cell text does NOT have to be an exact match--it is NOT case-sensitive and can be just a substring of the desired value in the table.

Fields: [ ]=Optional with Default Value
  1. BenchValue
    The case-sensitive expected value for the specified cell.


  2. Var
    The variable which gets assigned the row found.

    The variable which gets assigned the row found. If not found then it will get a zero length string

  3. Col
    The 1-based cell column # in the row/col specification or fuzzy column header text.

    The routine will first attempt to fuzzy-match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number.

  4. ColN
    A 1-based cell column # in the row/col specification or fuzzy column header text.

    The routine will first attempt to fuzzy-match any provided value with a field header. If no match is found, it will expect the value to be a valid 1-based column number. This must be accompanied by the next parameter, 'ValueN', and as many of the ColN/ValueN parameter pairs can be supplied as desired in order to match for a row based on cell contents.

  5. ValueN
    A Value to search for in a cell under the 'ColN' column

    A Value to search for in a cell under the 'ColN' column

Examples:
  • T, DotNetWin, DotNetTable, VerifyFuzzyCellTextFind, "10/09/2003", Variable, "Da","Ti", "09:58 AM", "Cha","Change #2","Rev", "2"
    Verifies the cell in the row matching the colN/valueN values.

    Verifies the "Da" cell in the row fuzzy-matching the colN/valueN values: "Ti"/"09:58 AM", "Cha"/"Change #2", "Rev"/"2" is equal "10/09/2003". The variable 'Variable' will be assigned the matching row number.

[How To Read This Reference]