<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%") // Processes the result of the search IF sCell <> "" THEN // Replaces %CUSTOMERNAME% by Doe PSHEET_NoName1[sCell] = "Doe" END
// Browse all cells with "VAT" sCell is string = PSHEET_NoName1.Seek("%VAT%") WHILE sCell <> "" // Replaces VAT by PSHEET_NoName1[sCell] = 20.6 Trace(sCell) // Next cell sCell = PSHEET_NoName1.Seek("VAT", sCell) END
Syntax
<Result> = <Spreadsheet control>.Seek(<Sought 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. <Sought 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. Remark: this parameter is used to browse all cells containing a value. If this parameter is not specified or is an empty string (""), the search starts at cell "A1". <Options>: Optional Integer constant Search options: | | psheetSearchWithCase | Search while taking the case into account. | psheetSearchContain | "Contains" search. | psheetSearchInFormula | Search in the formulas only. | psheetSearchExact | "Exact" search. | psheetSearchCurrentWorksheet | Search in the current worksheet. | psheetSearchNoCase | Search ignoring the case. | psheetSearchAnyWorksheet | Search in all worksheets of workbook. |
By default, the search is performed according to the following combination of constants: psheetSearchWithCase + psheetSearchCurrentWorksheet + psheetSearchExact 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…
|
|
|
|