DataPilotTable

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

Methods

addFields

refreshTable

Creation and Access

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.

See examples

Example: DataPilotTable