<Pivot Table>.Load (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Controls, pages and windows / Pivot Table functions

Saving and loading the content of a Pivot Table control

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Pivot Table>.Load (Function)

In french: <Tableau croisé dynamique>.Charge

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

Save to file: Name and full path of the file to be loaded. This file corresponds to a file previously saved with <Pivot Table>.Save.
Memory backup: backup buffer returned by function <Pivot Table>.Save.

<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 <Pivot Table>.Save.
New in version 2025
Secret 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 <Pivot table>.CalculateAll, the result can be saved by <Pivot Table>.Save. It can then be reloaded using the function <Pivot Table>.Load function: in this case, the contents of the Pivot Table control field are not recalculated.

Component: wd300obj.dll