PC SOFT

AYUDA EN LÍNEA
DE WINDEV, WEBDEV Y WINDEV MOBILE


WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Otros
Procedimientos almacenados
MultiWorksheet (Property)
 
..MultiWorksheet is used to:
  • Find out whether a Spreadsheet control manages several worksheets.
  • Modify the mode for managing the worksheets in a Spreadsheet control.
Ejemplo
// Switches the Spreadsheet control to multi-worksheet mode to load an xlsx file
PSHEET_MySpreadsheet..MultiWorksheet = True
SpreadsheetLoad(PSHEET_MySpreadsheet, "FullDoc.xlsx")
Sintaxis

Finding out the management mode of worksheets Ocultar los detalles

<Result> = <Spreadsheet>..MultiWorksheet
<Result>: Boolean
  • True if the Spreadsheet control manages several worksheets,
  • False if the Spreadsheet control manages a single worksheet.
<Spreadsheet>: Character string (with or without quotes)
Name of the Spreadsheet control to use.

Modifying the mode for managing the worksheets Ocultar los detalles

<Spreadsheet>..MultiWorksheet = <New Management Mode>
<Spreadsheet>: Character string (with or without quotes)
Name of the Spreadsheet control to use.
<New Management Mode>: Boolean
  • True if the Spreadsheet control must manage several worksheets,
  • False if the Spreadsheet control must manage a single worksheet.
Observaciones
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.
Versión mínima requerida
  • Versión 20
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario