<Spreadsheet>.Seek (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Spreadsheet>.Seek (Function)

In french: <Tableur>.Cherche

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

Example

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 search.
Remark: this parameter is used to browse all cells containing a value.
If this parameter is not specified, the search is performed from the "A1" cell.

<Options>: Optional Integer constant

Versions 23 and later
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
New in version 23
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
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.

Component: wd270obj.dll