Functions for managing Pivot Table controls (prefixed syntax)

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Functions for managing Pivot Table controls (prefixed syntax)

These functions are used to handle the Pivot Table controls (prefixed syntax):


<Pivot table>.AxisXY	Allows you to: Specify the row and column headers displayed in a Pivot Table control. Find out the row and column headers displayed in a Pivot Table control.
<Pivot table>.CalculateAll	Entirely calculates or recalculates a Pivot Table control.
<Pivot table>.CalculateUpdate	Updates some of the data found in a Pivot Table control from a given date.
<Pivot table>.Collapse	Collapses the data found in a Pivot Table control according to a row header or to a column header.
<Pivot table>.CollapseAll	Collapses all row and/or column headers in a Pivot Table control.
<Pivot table>.Expand	Expands the data found in a Pivot Table control according to a row header or to a column header.
<Pivot table>.ExpandAll	Expands all row and/or column headers in a Pivot Table control.
<Pivot table>.Filter	Enables or disables a filter on a Pivot Table control.
<Pivot table>.HeaderValue	Returns the value displayed in a header of Pivot Table control.
<Pivot table>.InfoXY	Returns the values of headers corresponding to a position in a Pivot Table control in pixels.
<Pivot table>.ListPositionHeader	Returns all values associated with a row or column header in a Pivot Table control.
<Pivot table>.Load	Loads the result of the calculation performed in a Pivot Table control from a backup (file found on disk or backup in a buffer).
<Pivot table>.Save	Saves the result of the calculation performed in a Pivot Table control (in a file or in memory).
<Pivot table>.Select	Allows you to find out the position of selected cells and to select cells in a Pivot Table control.
<Pivot table>.SelectCount	Returns the number of selected cells in a Pivot Table control.
<Pivot table>.ToExcel	Creates an Excel file with data from a Pivot Table control.

Related Examples:

Training (WINDEV): WD PivotTable

[ + ] This example presents the use of the Pivot Table control.

This Pivot Table control is used to display dynamic statistics while grouping the data.
These statistics are calculated form the database.