PC SOFT

WINDEVWEBDEV 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
..NbWorksheet is used to find out the number of worksheets in a Spreadsheet control.
Example
// Browse the wooksheets found in PSHEET_MySpreadsheet
FOR i = 1 TO PSHEET_MySpreadsheet..NbWorksheet
PSHEET_MySpreadsheet..CurrentWorksheet = i
PSHEET_MySpreadsheet["A1"] = "On the worksheet " + i
END
Syntax
<Result> = <Spreadsheet>..NbWorksheet
<Result>: Integer
Number of worksheets found in the Spreadsheet control.
<Spreadsheet>: Character string (with or without quotes)
Name of the Spreadsheet control to use.
Remarks
  • To manage more than one worksheet, the Spreadsheet control must allow the management of several worksheets:
    • In the editor: In the "Details" tab of the description window of the control, check "Allow the management of several worksheets".
    • By programming, use ..MultiWorksheet.
  • The worksheets can be created:
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment