<Pivot Table>.Save (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 a Pivot Table control

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Pivot Table>.Save (Function)

In french: <Tableau croisé dynamique>.Sauve

Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). This backup can be reloaded in a Pivot Table control by <Pivot Table>.Load.

Example

sFichier is string
// Construit le nom du fichier
sFichier = SysDir(srAppData) + ["\"] + "StatsParPays.tcd"

// Le fichier existe?
IF fFileExist(sFichier) THEN
	// Oui, on le charge 
	TCD_Statistiques.Charge(sFichier)
	IF YesNo("Voulez-vous tout recalculer?") THEN TCD_Statistiques.CalculeTout()
ELSE
	// Le fichier n'existe pas, on le calcule
	TCD_Statistiques.CalculeTout()
END
TCD_Statistiques.Sauve(sFichier)

Syntax

Saving a Pivot Table control with its interface and a password Hide the details

<Result> = <Pivot Table control>.Save(<Backup media> [, <Backup mode> [, <Password>]])

<Result>: Type depending on the backup media

Memory backup: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
Backup in a file:
True if the backup was performed,
False otherwise.

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<Backup media>: Character string or constant

Save to memory: constant enMémoire: Saves the contents of the Pivot Table control in memory.. <Resultat> contains the backup result.
Save to file: Name and full path of the file to which the contents of the Pivot Table control will be saved.

<Backup mode>: Optional Integer constant

By default, only the data is saved. You also have the ability to save the interface of Pivot Table control:
pvtWithUI Saves the configuration of Pivot Table control:
size of columns,
size of rows,
collapsed/expanded row headers or column headers.
Note: Prior to version 25, this constant was called tcdAveHM.
If <Backup mode> and <Password> are not specified, only the found in the Pivot Table control will be saved and the backup will not be password protected. To save the data only and to protect the backup by a password, use the syntax 2.

<Password>: Optional character string

Backup password. If the backup is password protected, this password will have to be specified when the backup is loaded by <Pivot Table>.Load.

Saving a Pivot Table control without its interface and with a password Hide the details

<Result> = <Pivot Table control>.Save(<Backup media> [, <Password>])

<Result>: Type depending on the backup media

Memory backup: Buffer containing the backup. Then, this backup can be saved in a file (fSaveBuffer), ...
Backup in a file:
True if the backup was performed,
False otherwise.

<Pivot Table control>: Control name

Name of the Pivot Table control to be used.

<Backup media>: Character string or constant

Save to memory: constant enMémoire: Saves the contents of the Pivot Table control in memory.. <Resultat> contains the backup result.
Save to file: Name and full path of the file to which the contents of the Pivot Table control will be saved.

<Password>: Optional character string

Backup password. If the backup is password protected, this password will have to be specified when the backup is loaded by <Pivot Table>.Load.

Remarks

Saving and loading a Pivot Table control

When the content of a Pivot Table control is calculated with <Pivot table>.CalculateAll, the result can be saved with <Pivot Table>.Save. It can then be reloaded using function <Pivot Table>.Load: in this case, the contents of the Pivot Table control field are not recalculated..

Component: wd300obj.dll