|
|
|
|
|
- Saving and loading the content of a Pivot Table control
<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. 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|