SpreadsheetSeek (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SpreadsheetSeek (Function)

In french: TableurCherche

Seeks a value in the cells of a Spreadsheet control found in a window.

Example

sCell is string = SpreadsheetSeek(TBLR_SansNom1, "%NOMCLIENT%")
// Traite le résultat de la recherche
IF sCell <> "" THEN
	 // Remplace %NOMCLIENT% par Durant
	 TBLR_SansNom1[sCell] = "Durant"
END

// Parcours de toutes les cellules avec "TVA"
sCell is string = SpreadsheetSeek(TBLR_SansNom1, "TVA")
WHILE  sCell <> ""
	// Remplace TVA par TBLR_SansNom1[sCell] = 20.6
	Trace(sCell)
	// Cellule suivante
	sCell = SpreadsheetSeek(TBLR_SansNom1, "TVA", sCell)
END

Syntax

<Result> = SpreadsheetSeek(<Spreadsheet control> , <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.

Component: wd300obj.dll