ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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 the Pivot Table control to be used.
<Backup media>: Character string or Buffer
  • Backup in a file: Name and full path of file to load. This file corresponds to a file previously saved with <Pivot table>.Save.
  • Backup in memory: Backup buffer returned by <Pivot table>.Save.
<Password>: Optional character string
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 loaded again using <Pivot table>.Load: in this case, the content of the Pivot Table control is not recalculated.
Component: wd290obj.dll
Minimum version required
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/21/2023

Send a report | Local help