add method

This method creates a new DataPilot table.

Defined in

DataPilotTables

Syntax

public DataPilotTable add(Range source, String name, Range destination) throws SymphonyException

Parameters

Range source

Specifies the range that contains the data. If the range is in another sheet, this method throws an exception.

String name

Specifies the name of the table.

Range destination

Specifies the position to display the table.

Return Value

dataPilotTable

A DataPilotTable object that represents a DataPilot table.

Usage

After calling the Add method, a DataPilot table is created, but there is no data in the table. Use the addFields method to fill data in the table:
  • Add column fields for the table, each column field must be a column of the source range.
  • Add row fields for the table, each row field must be a column of the source range.
  • Add data fields for the table, each data field must be a column of the source range.
  • Add page fields for the table, each page field must be a column of the source range.

See examples

Example: add method