class

TimelineCollection

Source: aspose.cells.doc.js:87281

Specifies the collection of all the Timeline objects on the specified worksheet. Due to MS Excel, Excel 2003 does not support Timeline.

Methods

add(pivot, row, column, baseFieldName)
add(pivot, destCellName, baseFieldName)
add(pivot, row, column, baseFieldIndex)
add(pivot, destCellName, baseFieldIndex)
add(pivot, row, column, baseField)
add(pivot, destCellName, baseField)
add()
clear()
contains()
get()
get()
get()
getCount()
indexOf()
iterator()
removeAt()

Methods

add(pivot, row, column, baseFieldName) → Number

Add a new Timeline using PivotTable as data source

Parameters

Name Type Optional 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 The new add Timeline index

add(pivot, destCellName, baseFieldName) → Number

Add a new Timeline using PivotTable as data source

Parameters

Name Type Optional 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 The new add Timeline index

add(pivot, row, column, baseFieldIndex) → Number

Add a new Timeline using PivotTable as data source

Parameters

Name Type Optional 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 The new add Timeline index

add(pivot, destCellName, baseFieldIndex) → Number

Add a new Timeline using PivotTable as data source

Parameters

Name Type Optional 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 The new add Timeline index

add(pivot, row, column, baseField) → Number

Add a new Timeline using PivotTable as data source

Parameters

Name Type Optional 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 The new add Timeline index

add(pivot, destCellName, baseField) → Number

Add a new Timeline using PivotTable as data source

Parameters

Name Type Optional 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 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.

iterator()

removeAt()