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.
Methods
| Name | Description |
|---|---|
| add(pivot, row, column, baseFieldName) | Add a new Timeline using PivotTable as data source |
| add(pivot, destCellName, baseFieldName) | Add a new Timeline using PivotTable as data source |
| add(pivot, row, column, baseFieldIndex) | Add a new Timeline using PivotTable as data source |
| add(pivot, destCellName, baseFieldIndex) | Add a new Timeline using PivotTable as data source |
| add(pivot, row, column, baseField) | Add a new Timeline using PivotTable as data source |
| add(pivot, destCellName, baseField) | Add a new Timeline using PivotTable as data source |
| add() | Reserved for internal use. |
| clear() | |
| contains() | Reserved for internal use. |
| get() | Gets the Timeline by index. |
| get() | Gets the Timeline by Timeline’s name. |
| get() | Reserved for internal use. |
| getCount() | |
| indexOf() | Reserved for internal use. |
| iterator() | |
| removeAt() |
add(pivot, row, column, baseFieldName)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| row | Number | Row index of the cell in the upper-left corner of the Timeline range. |
| column | Number | Column index of the cell in the upper-left corner of the Timeline range. |
| baseFieldName | String | The name of PivotField in PivotTable.BaseFields |
Returns: Number — Number The new add Timeline index
add(pivot, destCellName, baseFieldName)
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: Number — Number The new add Timeline index
add(pivot, row, column, baseFieldIndex)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| row | Number | Row index of the cell in the upper-left corner of the Timeline range. |
| column | Number | Column index of the cell in the upper-left corner of the Timeline range. |
| baseFieldIndex | Number | The index of PivotField in PivotTable.BaseFields |
Returns: Number — Number The new add Timeline index
add(pivot, destCellName, baseFieldIndex)
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 | Number | The index of PivotField in PivotTable.BaseFields |
Returns: Number — Number The new add Timeline index
add(pivot, row, column, baseField)
Add a new Timeline using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| row | Number | Row index of the cell in the upper-left corner of the Timeline range. |
| column | Number | Column index of the cell in the upper-left corner of the Timeline range. |
| baseField | PivotField | The PivotField in PivotTable.BaseFields |
Returns: Number — Number The new add Timeline index
add(pivot, destCellName, baseField)
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: Number — Number The new add Timeline index
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
get()
Gets the Timeline by index.
get()
Gets the Timeline by Timeline’s name.
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.