|
|
|
|
WorksheetName (Property) In french: NomFeuille
The WorksheetName property is used to get or change the name of the current worksheet in a Spreadsheet control. Reminder: If several worksheets are managed by the Spreadsheet control, the name of the worksheet appears in the tab used to select the worksheet (at the bottom of the Spreadsheet control). // Finds out whether a worksheet is named "US_Stat" FOR I = 1 TO PSHEET_MySpreadsheet.NbWorksheet PSHEET_MySpreadsheet.CurrentWorksheet = I IF PSHEET_MySpreadsheet.WorksheetName = "US_Stat" THEN RESULT I // Worksheet found END END // Worksheet not found RESULT 0
Syntax
Getting the name of the current worksheet Hide the details
<Result> = <Spreadsheet control>.WorksheetName
<Result>: Character string Name of the current worksheet in the Spreadsheet control. <Spreadsheet control>: Control name Name of the Spreadsheet control to be used.
Modifying the name of the current worksheet Hide the details
<Spreadsheet control>.WorksheetName = <New name>
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <New name>: Character string New name for the worksheet. The maximum size of this name is 32 characters.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|