ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
The NbWorksheet property is used to get 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 control>.NbWorksheet
<Result>: Integer
Number of worksheets found in the Spreadsheet control.
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
Remarks
  • To manage more than one spreadsheet, the Spreadsheet control field must allow multiple spreadsheets to be managed:
    • In the editor: In the "Detail" tab of the control description window, check the "Allow multiple worksheets" option..
    • Use the MultiWorksheet property.
  • Sheets can be created:
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/10/2025

Send a report | Local help