|
|
|
|
|
|
|
|
|
|
MultiWorksheet (Property) In french: MultiFeuille
The MultiWorksheet property is used to: - Find out whether a Spreadsheet control manages several worksheets.
- Change the worksheet management mode of a Spreadsheet control..
// Switches the Spreadsheet control to multi-worksheet mode to load an xlsx file
PSHEET_MySpreadsheet.MultiWorksheet = True
SpreadsheetLoad(PSHEET_MySpreadsheet, "FullDoc.xlsx")
Syntax
Finding out the management mode of worksheets Hide the details
<Result> = <Spreadsheet control>.MultiWorksheet
<Result>: Boolean - True if the Spreadsheet control manages several worksheets,
- False if the Spreadsheet control manages a single worksheet.
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used.
Modifying the mode for managing the worksheets Hide the details
<Spreadsheet control>.MultiWorksheet = <New mode>
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <New mode>: Boolean - True if the Spreadsheet control must manage several worksheets,
- False if the Spreadsheet control must manage a single worksheet.
Remarks If the multi-worksheet management mode is enabled: - Buttons for managing the worksheets are displayed in the control.
- The loaded and saved XLSX documents manage all the worksheets (SpreadsheetLoad and SpreadsheetSave).
If the multi-worksheet management mode is not enabled: - SpreadsheetLoad loads a single worksheet.
- No button for worksheet management is displayed.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|