|
|
|
|
|
|
|
|
NbWorksheet (Property) In french: NbFeuille
The NbWorksheet property is used to get the number of worksheets in a Spreadsheet control. // 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 - The Spreadsheet control must be configured to support multiple worksheets, if necessary:
- In the editor: In the "Details" tab of the control description window, check "Allow multiple worksheets".
- Through programming, use the MultiWorksheet property.
- The worksheets can be created:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|