PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
SpreadsheetSeek (Function)
In french: TableurCherche
Seeks a value in the cells of a Spreadsheet control found in a window.
Example
sCell is string = SpreadsheetSeek(PSHEET_NoName1, "%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 = SpreadsheetSeek(PSHEET_NoName1, "VAT")
WHILE  sCell <> ""
// Replaces VAT by PSHEET_NoName1[sCell] = 20.6
Trace(sCell)
// Next cell
sCell = SpreadsheetSeek(PSHEET_NoName1, "VAT", sCell)
END
Syntax
<Result> = SpreadsheetSeek(<Spreadsheet control> , <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 Spreadsheet control to use.
<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.
Note: 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:
psheetSearchWithCaseSearch while taking the case into account.
psheetSearchContain"Contains" search.
psheetSearchInFormulaSearch in the formulas only.
psheetSearchExact"Exact" search.
psheetSearchCurrentWorksheetSearch in the current worksheet.
psheetSearchNoCaseSearch while ignoring the case.
psheetSearchAnyWorksheetSearch 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:
psheetSearchWithCaseSearch while taking the case into account.
psheetSearchContain"Contains" search.
psheetSearchInFormulaSearch in the formulas only.
psheetSearchExact"Exact" search.
psheetSearchCurrentWorksheetSearch in the current worksheet.
psheetSearchNoCaseSearch while ignoring the case.
psheetSearchAnyWorksheetSearch in all worksheets of workbook.

By default, the search is performed according to the following combination of constants: psheetSearchWithCase + psheetSearchCurrentWorksheet + psheetSearchExact
Search options:
psheetSearchWithCaseSearch while taking the case into account.
psheetSearchContain"Contains" search.
psheetSearchInFormulaSearch in the formulas only.
psheetSearchExact"Exact" search.
psheetSearchCurrentWorksheetSearch in the current worksheet.
psheetSearchNoCaseSearch while ignoring the case.
psheetSearchAnyWorksheetSearch 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 : wd240obj.dll
See also
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment