|
|
|
|
|
|
|
|
|
|
- Saving and loading the content of a Pivot Table control
PVTLoad (Function) In french: TCDCharge Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer). This calculation was saved beforehand by PVTSave. sFichier is string
sFichier = SysDir(srAppData) + ["\"] + "StatsParPays.tcd"
IF fFileExist(sFichier) THEN
PVTLoad(TCD_Statistiques, sFichier)
IF YesNo("Voulez-vous tout recalculer ?") THEN PVTCalculateAll(TCD_Statistiques)
ELSE
PVTCalculateAll(TCD_Statistiques)
END
PVTSave(TCD_Statistiques, sFichier)
Syntax
<Result> = PVTLoad(<Pivot Table control> , <Backup media> [, <Password>])
<Result>: Boolean - True if the content of the Pivot Table control was loaded.
- False otherwise
<Pivot Table control>: Control name Name of the Pivot Table control to be used. <Backup media>: Character string or Buffer - Save to file: Name and full path of the file to be loaded. This file corresponds to a file previously saved with PVTSave.
- Memory backup: backup buffer returned by function PVTSave.
<Password>: Optional string or Secret string Password associated with the backup of the Pivot Table control. This password was specified when the Pivot Table control was saved by PVTSave.
 New in version 2025Secret strings: If you use the secret string vault, the type of secret string used for this parameter must be "ANSI or Unicode string". To learn more about secret strings and how to use the vault, see Secret string vault. Remarks Saving and loading the content of a Pivot Table control When the Pivot Table control is calculated by PVTCalculateAll, the result can be saved by PVTSave. It can then be reloaded using the function PVTLoad function: in this case, the contents of the Pivot Table control field are not recalculated. Business / UI classification: UI Code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|