TimelineCollection
TimelineCollection class
Specifies the collection of all the Timeline objects on the specified worksheet. Due to MS Excel, Excel 2003 does not support Timeline.
Properties
| Name | Type | Description |
|---|---|---|
| Count | int | |
| Item (int) | Timeline | Gets the Timeline by index. |
| Item (java.lang.String) | Timeline | Gets the Timeline by Timeline’s name. |
Methods
| Name | Description |
|---|---|
| add | Add a new Timeline using PivotTable as data source |
| clear | |
| removeAt | |
| iterator | |
| get | Reserved for internal use. |
| contains | Reserved for internal use. |
| indexOf | Reserved for internal use. |
TimelineCollection.Count property
Type: int
TimelineCollection.Item (int) property
Gets the Timeline by index.
Type: Timeline
TimelineCollection.Item (java.lang.String) property
Gets the Timeline by Timeline’s name.
Type: Timeline
add(pivot, row, column, baseFieldName) (1 of 7)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| row | int | Row index of the cell in the upper-left corner of the Timeline range. |
| column | int | Column index of the cell in the upper-left corner of the Timeline range. |
| baseFieldName | String | The name of PivotField in PivotTable.BaseFields |
Returns: The new add Timeline index
add(pivot, destCellName, baseFieldName) (2 of 7)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| destCellName | String | The cell name in the upper-left corner of the Timeline range. |
| baseFieldName | String | The name of PivotField in PivotTable.BaseFields |
Returns: The new add Timeline index
add(pivot, row, column, baseFieldIndex) (3 of 7)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| row | int | Row index of the cell in the upper-left corner of the Timeline range. |
| column | int | Column index of the cell in the upper-left corner of the Timeline range. |
| baseFieldIndex | int | The index of PivotField in PivotTable.BaseFields |
Returns: The new add Timeline index
add(pivot, destCellName, baseFieldIndex) (4 of 7)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| destCellName | String | The cell name in the upper-left corner of the Timeline range. |
| baseFieldIndex | int | The index of PivotField in PivotTable.BaseFields |
Returns: The new add Timeline index
add(pivot, row, column, baseField) (5 of 7)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| row | int | Row index of the cell in the upper-left corner of the Timeline range. |
| column | int | Column index of the cell in the upper-left corner of the Timeline range. |
| baseField | PivotField | The PivotField in PivotTable.BaseFields |
Returns: The new add Timeline index
add(pivot, destCellName, baseField) (6 of 7)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| destCellName | String | The cell name in the upper-left corner of the Timeline range. |
| baseField | PivotField | The PivotField in PivotTable.BaseFields |
Returns: The new add Timeline index
add(value) (7 of 7)
Reserved for internal use.
clear()
removeAt(index)
iterator()
get(index)
Reserved for internal use.
contains(value)
Reserved for internal use.
indexOf(value)
Reserved for internal use.