findString

findString(str:           String;
           row:           Integer io;
           column:        Integer io;
           caseSensitive: Boolean;
           exact:         Boolean): Boolean;

The findString method of the JadeTableSheet class searches the cells in a sheet of a Table control for the string specified in the str parameter. The search starts at the cell row and column specified by the respective row and column parameter values or at the first row and column if the parameter values are less than 1. The case‑sensitivity of the search is determined by the value of the caseSensitive parameter.

If the exact parameter value is false, the search matches any cell text with the specified prefix. If the exact parameter value is true, the search matches only cells whose text is an exact match.

If the search does not find a cell containing the string with the required caseSensitive and exact parameter values, this method returns false. If the search finds a cell containing the string with the required case‑sensitive and exact options, this method returns true and the row and column of the located cell are returned; for example:

col := 0;
row := 0;
while table1.accessSheet(1).findString("city", row, col, false, false) do
    ....
    col := col + 1; // repeat the search starting in the next column
endwhile;

2016.0.02 (Service Pack 1) and higher