PC SOFT

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

  • Saving and loading a pivot table
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
PVTSave (Function)
 
Saves the result of the calculation performed in a Pivot Table control in a file. This backup can be reloaded in a Pivot Table control by PVTLoad. Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). This backup can be reloaded in a Pivot Table control by PVTLoad.
Ejemplo
sFile is string
// Builds the file name
sFile = SysDir(srAppData) + ["\"] + "StatsByCountry.tcd"

// The file exists?
IF fFileExist(sFile) THEN
// Yes, load it
PVTLoad(PVT_Statistics, sFile)
IF YesNo("Do you want to recalculate everything?") THEN PVTCalculateAll(PVT_Statistics)
ELSE
// The file does not exist, calculate it
PVTCalculateAll(PVT_Statistics)
END
PVTSave(PVT_Statistics, sFile)
Sintaxis

Saving a Pivot Table control with its interface and a password Ocultar los detalles

PVTSave(<Pivot Table> , <File to save> [, <Backup mode> [, <Password>]])
<Pivot Table>: Character string (with or without quotes)
Name of Pivot Table control to use.
<File to save>: Character string (with quotes)
Name and full path of the file where the content of Pivot Table control will be saved.
<Backup mode>: Optional Integer constant
By default, only the data is saved. You also have the ability to save the interface of Pivot Table control:
pvtWithGUISaves the configuration of Pivot Table control:
  • size of columns,
  • size of rows,
  • collapsed/expanded row headers or column headers.
Versiones 19 y posteriores
If <Backup Mode> and <Password> are not specified, only the data found in the Pivot Table control will be saved and the file will not be password protected. To save the data only and to protect the backup file by a password, use the syntax 2.
Nueva funcionalidad versión 19
If <Backup Mode> and <Password> are not specified, only the data found in the Pivot Table control will be saved and the file will not be password protected. To save the data only and to protect the backup file by a password, use the syntax 2.
If <Backup Mode> and <Password> are not specified, only the data found in the Pivot Table control will be saved and the file will not be password protected. To save the data only and to protect the backup file by a password, use the syntax 2.
<Password>: Optional character string (with quotes)
Versiones 19 y posteriores
Password of backup file. If the file is password protected, this password will have to be specified when the file is loaded by PVTLoad.
Nueva funcionalidad versión 19
Password of backup file. If the file is password protected, this password will have to be specified when the file is loaded by PVTLoad.
Password of backup file. If the file is password protected, this password will have to be specified when the file is loaded by PVTLoad.

Saving a Pivot Table control with its interface and a password Ocultar los detalles

<Result> = PVTSave(<Pivot Table control> , <Backup media> [, <Backup mode> [, <Password>]])
<Result>: Type depending on the backup media
Versiones 21 y posteriores
  • Backup in memory: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
  • Backup in a file:
    • True if the backup was performed,
    • False otherwise.
Nueva funcionalidad versión 21
  • Backup in memory: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
  • Backup in a file:
    • True if the backup was performed,
    • False otherwise.
  • Backup in memory: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
  • Backup in a file:
    • True if the backup was performed,
    • False otherwise.
<Pivot Table control>: Control name
Name of Pivot Table control to use.
<Backup media>: Character string (with quotes) or constant
  • Versiones 21 y posteriores
    Backup in memory: inMemory constant: Saves the content of the Pivot Table control in memory. <Resultat> contains the backup result.
    Nueva funcionalidad versión 21
    Backup in memory: inMemory constant: Saves the content of the Pivot Table control in memory. <Resultat> contains the backup result.
    Backup in memory: inMemory constant: Saves the content of the Pivot Table control in memory. <Resultat> contains the backup result.
  • Backup in a file: Name and full path of the file where the content of Pivot Table control will be saved.
<Backup mode>: Optional Integer constant
By default, only the data is saved. You also have the ability to save the interface of Pivot Table control:
pvtWithGUISaves the configuration of Pivot Table control:
  • size of columns,
  • size of rows,
  • collapsed/expanded row headers or column headers.
Versiones 19 y posteriores
If <Backup Mode> and <Password> are not specified, only the data found in the Pivot Table control will be saved and the backup will not be password protected. To save the data only and to protect the backup by a password, use the syntax 2.
Nueva funcionalidad versión 19
If <Backup Mode> and <Password> are not specified, only the data found in the Pivot Table control will be saved and the backup will not be password protected. To save the data only and to protect the backup by a password, use the syntax 2.
If <Backup Mode> and <Password> are not specified, only the data found in the Pivot Table control will be saved and the backup will not be password protected. To save the data only and to protect the backup by a password, use the syntax 2.
<Password>: Optional character string (with quotes)
Versiones 19 y posteriores
Password for the backup. If the backup is password protected, this password will have to be specified when the backup is loaded by PVTLoad.
Nueva funcionalidad versión 19
Password for the backup. If the backup is password protected, this password will have to be specified when the backup is loaded by PVTLoad.
Password for the backup. If the backup is password protected, this password will have to be specified when the backup is loaded by PVTLoad.
Versiones 19 y posteriores

Saving a Pivot Table control without its interface and with a password Ocultar los detalles

PVTSave(<Pivot Table> , <File to save> [, <Password>])
<Pivot Table>: Character string (with or without quotes)
Name of Pivot Table control to use.
<File to save>: Character string (with quotes)
Name and full path of the file where the content of Pivot Table control will be saved.
<Password>: Optional character string (with quotes)
Password of backup file. If the file is password protected, this password will have to be specified when the file is loaded by PVTLoad.
Nueva funcionalidad versión 19

Saving a Pivot Table control without its interface and with a password Ocultar los detalles

PVTSave(<Pivot Table> , <File to save> [, <Password>])
<Pivot Table>: Character string (with or without quotes)
Name of Pivot Table control to use.
<File to save>: Character string (with quotes)
Name and full path of the file where the content of Pivot Table control will be saved.
<Password>: Optional character string (with quotes)
Password of backup file. If the file is password protected, this password will have to be specified when the file is loaded by PVTLoad.

Saving a Pivot Table control without its interface and with a password Ocultar los detalles

PVTSave(<Pivot Table> , <File to save> [, <Password>])
<Pivot Table>: Character string (with or without quotes)
Name of Pivot Table control to use.
<File to save>: Character string (with quotes)
Name and full path of the file where the content of Pivot Table control will be saved.
<Password>: Optional character string (with quotes)
Password of backup file. If the file is password protected, this password will have to be specified when the file is loaded by PVTLoad.

Saving a Pivot Table control without its interface and with a password Ocultar los detalles

<Result> = PVTSave(<Pivot Table control> , <Backup media> [, <Password>])
<Result>: Type depending on the backup media
Versiones 21 y posteriores
  • Backup in memory: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
  • Backup in a file:
    • True if the backup was performed,
    • False otherwise.
Nueva funcionalidad versión 21
  • Backup in memory: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
  • Backup in a file:
    • True if the backup was performed,
    • False otherwise.
  • Backup in memory: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
  • Backup in a file:
    • True if the backup was performed,
    • False otherwise.
<Pivot Table control>: Control name
Name of Pivot Table control to use.
<Backup media>: Character string (with quotes) or constant
  • Versiones 21 y posteriores
    Backup in memory: inMemory constant: Saves the content of the Pivot Table control in memory. <Resultat> contains the backup result.
    Nueva funcionalidad versión 21
    Backup in memory: inMemory constant: Saves the content of the Pivot Table control in memory. <Resultat> contains the backup result.
    Backup in memory: inMemory constant: Saves the content of the Pivot Table control in memory. <Resultat> contains the backup result.
  • Backup in a file: Name and full path of the file where the content of Pivot Table control will be saved.
<Password>: Optional character string (with quotes)
Password for the backup. If the backup is password protected, this password will have to be specified when the backup is loaded by PVTLoad.
Observaciones

Saving and loading a pivot table

When the pivot table is calculated by PVTCalculateAll, the result can be saved by PVTSave. Then, it can be reloaded by PVTLoad: in this case, the pivot table is not recalculated.
Componente : wd240obj.dll
Versión mínima requerida
  • Versión 18
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario