This method creates a new DataPilot table.
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.