PC SOFT

WINDEV的在线文档

版本: 20.0

类别: Pivot Table functions
The following constants are used by the functions for managing the pivot tables
Functions for managing the Pivot Table controls
Returns the values of headers corresponding to a position in a Pivot Table control in pixels.
Used 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.
The 数据透视表位置型 type is used to handle a cell of a Pivot Table control.
Saves the result of the calculation performed in a Pivot Table control in a file.
Returns all the values associated with a row or column header in a Pivot Table control.
Creates an Excel file from the data found in a pivot table.
Loads the result of the calculation performed in a Pivot Table control from a file found on disk.
Collapses the data found in a Pivot Table control according to a row header or to a column header.
Expands the data found in a Pivot Table control according to a row header or to a column header.
Expands all the row headers and/or column headers in a pivot table.
Collapses all the row headers and/or column headers in a pivot table.
Returns the value displayed in an header of a Pivot Table control.
Entirely calculates or recalculates a pivot table.
Updates some of the data found in a pivot table from a given date.
Enables or disables a filter on a Pivot Table control.
Allows you to find out the position of selected cells and to select cells in a Pivot Table control.