PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Returns the list of names that identify a cell in a Spreadsheet control.
Example
tabNom is array of strings
tabNom = SpreadsheetListName(TBLR_MonTableur)
FOR EACH sDesc1Nom OF tabNom
sNom is string  = ExtractString(sDesc1Nom, 1, TAB)
sCellule is string  = ExtractString(sDesc1Nom, 2, TAB)
sPortée is string = ExtractString(sDesc1Nom, 3, TAB)
sCommentaire is string = ExtractString(sDesc1Nom, 4, TAB)
Trace("Nom: " + sNom + "; " + "Cellule: " + sCellule + "; " + ...
 "Portée: " + sPortée + ";" + "Commentaire: " + sCommentaire)
END
Syntax
<Result> = SpreadsheetListName(<Spreadsheet control>)
<Result>: Array
Array of strings containing the description of different cell names found in the control. Each array element has the following format:
<Nom>+TAB+<Cellule>+TAB+<Portée>+TAB+<Commentaire>
where:
  • <Name> corresponds to the cell name.
  • <Cell> corresponds to the cell identified by the name.
  • <Scope> corresponds to the scope of cell name:
    • 0 if the scope corresponds to the workbook,
    • 1 if the scope corresponds to the worksheet.
  • <Comment> corresponds to the comment associated with the cell name.
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
Component: wd270obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment