<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

Prefix syntax

Load

Presentation

Example

Saving and loading the content of a Pivot Table control

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

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: wd270obj.dll