|
|
|
|
|
|
|
|
|
|
<Spreadsheet>.Seek (Función) Seeks a value in the cells of a Spreadsheet control found in a window. sCell is string = TBLR_SansNom1.Cherche("%NOMCLIENT%")
IF sCell <> "" THEN
TBLR_SansNom1[sCell] = "Durant"
END
sCell is string = TBLR_SansNom1.Cherche("TVA")
WHILE sCell <> ""
Trace(sCell)
sCell = TBLR_SansNom1.Cherche("TVA", sCell)
END
Sintaxis
<Result> = <Spreadsheet control>.Seek(<Search value> [, <Start> [, <Options>]])
<Result>: Cadena de caracteres - 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>: Nombre del control Name of the Spreadsheet control to be used. <Search value>: Tipo de valor buscado Value to find in the cells of Spreadsheet control. This value can correspond to a number or to a character string. <Start>: Cadena de caracteres opcional 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>: Constante opcional de tipo Integer 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 Observaciones - 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.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|