PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The MultiWorksheet property is used to:
  • Find out whether a Spreadsheet control manages several worksheets.
  • Change the worksheet management mode of a Spreadsheet control..
Example
// 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.
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment