|
|
|
|
|
<Spreadsheet>.Seek (Function) In french: <Tableur>.Cherche Seeks a value in the cells of a Spreadsheet control found in a window. sCell is string = PSHEET_NoName1.Seek("%CUSTOMERNAME%")
IF sCell <> "" THEN
PSHEET_NoName1[sCell] = "Doe"
END
sCell is string = TBLR_SansNom1.Cherche("TVA")
WHILE sCell <> ""
Trace(sCell)
sCell = TBLR_SansNom1.Cherche("TVA", sCell)
END
Syntax
<Result> = <Spreadsheet control>.Seek(<Search value> [, <Start> [, <Options>]])
<Result>: Character string - Name of cell found ("A1" for example). If several cells are found, <Result> contains the name of first cell found.
- "" (empty string) if no cell is found.
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Search value>: Type of sought value Value to find in the cells of Spreadsheet control. This value can correspond to a number or to a character string. <Start>: Optional character string Name of the from which the search will be performed. This cell is excluded from the research. Note: this parameter scrolls through all cells containing a. If this parameter is not specified or is an empty string (""), the search starts at cell "A1". <Options>: Optional Integer constant Search options: | | psheetSearchWithCase | Case-sensitive search. | psheetSearchContain | "Contains" search. | psheetSearchInFormula | Search only in formulas. | psheetSearchExact | Exact-match search. | psheetSearchCurrentWorksheet | Search in the current worksheet. | psheetSearchNoCase | Case-insensitive search. | psheetSearchAnyWorksheet | Search in all sheets of the workbook. |
By default, the search is based on the following combination of constants: tblrRechAvecCasse + tblrRechFeuilleEnCours + tblrRechExact Remarks - The search is performed in the following order: A1, B1, C1, ..., A2, B2, C2, ...
- This function can only be used on a Spreadsheet control found in a window.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|