..WorksheetName is used to find out and modify 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
Sintaxis
Finding out the name of the current worksheet Ocultar los detalles
<Result> = <Spreadsheet>..WorksheetName
<Result>: Character string
Name of the current worksheet in the Spreadsheet control.
<Spreadsheet>: Character string (with or without quotes)
Name of Spreadsheet control to use.
Modifying the name of the current worksheet Ocultar los detalles
<Spreadsheet>..WorksheetName = <New Name>
<Spreadsheet>: Character string (with or without quotes)
Name of Spreadsheet control to use.
<New Name>: Character string (with quotes)
New name for the worksheet. The maximum size of this name is 32 characters.