This class represents a DataPilot table reports on a sheet.
Properties
Application through getApplication
ColumnFields through getColumnFields
DataFields through getDataFields
HiddenFields through getHiddenFields
PageFields through getPageFields
Name through getName and setName
RowFields through getRowFields
Usage
Datapilot table is a reporting tool that sorts and sums independent of the original data layout in the spreadsheet, it provides access to row fields (used as row), column fields (used as column), data fields (used as data), and hidden fields.
To add fields in the DataPilot table, use addFields method.