PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
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
The Property SheetName allows to know or modify the name of the current worksheet in an 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).
Example
// 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

Finding out the name of the current worksheet Hide the details

<Result> = <Spreadsheet control>SheetName
<Result>: Character string
Name of current worksheet in the Spreadsheet control.
<Spreadsheet control>: Control name
Name of Spreadsheet control to use.

Modifying the name of the current worksheet Hide the details

<Spreadsheet control>SheetName = <New name>
<Spreadsheet control>: Control name
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.
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment