PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Saving and loading the content of a Pivot Table control
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Loads the result of the calculation performed in a Pivot Table control from a file found on disk. This calculation was saved beforehand in a file by <Pivot table>.Save.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 <Pivot table>.Save.
Example
sFile is string
// Builds the file name
sFile = SysDir(srAppData) + ["\"] + "StatsByCountry.tcd"

// The file exists?
IF fFileExist(sFile) THEN
// Yes, load it
PVT_Statistics.Load(sFile)
IF YesNo("Do you want to recalculate everything?") THEN PVTCalculateAll(PVT_Statistics)
ELSE
// The file does not exist, calculate it
PVT_Statistics.CalculateAll()
END
PVT_Statistics.Save(sFile)
Syntax
<Result> = <Pivot Table control>.Load(<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 Pivot Table control to use.
<Backup media>: Character string (with quotes) or buffer
<Password>: Optional character string (with quotes)
Versions 19 and later
Password associated with the backup of the Pivot Table control. This password was specified when the Pivot Table control was saved by <Pivot table>.Save.
New in version 19
Password associated with the backup of the Pivot Table control. This password was specified when the Pivot Table control was saved by <Pivot table>.Save.
Password associated with the backup of the Pivot Table control. This password was specified when the Pivot Table control was saved by <Pivot table>.Save.
Remarks

Saving and loading the content of a Pivot Table control

When the Pivot Table control is calculated by <Pivot table>.CalculateAll, the result can be saved by <Pivot table>.Save. Then, it can be reloaded by <Pivot table>.Load: in this case, the content of the Pivot Table control is not recalculated.
Component : wd240obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment