DataPilotField

This class represents a field which can be a row, column, data, page or hidden field in a DataPilot table.

Properties

Application through getApplication

Function through getFunction and setFunction

Name through getName

Orientation through getOrientation and setOrientation

Creation and access
  • To add fields for a DataPilot table, use the addFields method in the DataPilotTable class.
  • To get a DataPilot field, use the Item method in theDataPilotFields class.

Usage

After a DataPilot table is created, all the columns in the source range are added to hidden fields. There are two ways to add row fields, column fields, page fields, and data fields :
See examples

Example: DataPilotField

Related information

DataPilotFields