|
|
|
|
|
SpreadsheetSelectWorksheet (Function) In french: TableurSelectFeuille Selects a worksheet (identified by its name) in a Spreadsheet control.
SpreadsheetSelectWorksheet(TBLR_MonTableur, SAI_NomFeuille_A_Sélectionner)
IF ErrorOccurred = True THEN
Error(ErrorInfo())
ELSE
LIB_MaFeuille = TBLR_MonTableur.FeuilleEncours
END
Syntax
SpreadsheetSelectWorksheet(<Spreadsheet control> , <Worksheet>)
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Worksheet>: Character string Name of the worksheet to select. Remarks - The index of the current worksheet is returned by CurrentWorksheet.
- The name of the current worksheet is returned by WorksheetName.
- If the sheet does not exist, the function raises a non-fatal error: variable ErrorOccurred is set to True and function ErrorInfo allows you to find out the cause of the error.
- This function can only be used on a Spreadsheet control found in a window.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|