aspose.cells

aspose.cells

Class TimelineCollection

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

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets the Timeline by index.
functionget(name)
Gets the Timeline by Timeline's name.
 
Method Summary
functionadd(pivot, row, column, baseField)
Add a new Timeline using PivotTable as data source
functionadd(pivot, row, column, baseFieldIndex)
Add a new Timeline using PivotTable as data source
functionadd(pivot, row, column, baseFieldName)
Add a new Timeline using PivotTable as data source
functionadd(pivot, destCellName, baseField)
Add a new Timeline using PivotTable as data source
functionadd(pivot, destCellName, baseFieldIndex)
Add a new Timeline using PivotTable as data source
functionadd(pivot, destCellName, baseFieldName)
Add a new Timeline using PivotTable as data source
functionadd(value)
Reserved for internal use.
functionclear()
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()

      • get : Timeline 

        function get(index)
        Gets the Timeline by index.

      • get : Timeline 

        function get(name)
        Gets the Timeline by Timeline's name.

    • Method Detail

      • add

        function add(pivot, row, column, baseFieldName)
        Add a new Timeline using PivotTable as data source
        Parameters:
        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:
        The new add Timeline index

      • add

        function add(pivot, destCellName, baseFieldName)
        Add a new Timeline using PivotTable as data source
        Parameters:
        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

        function add(pivot, row, column, baseFieldIndex)
        Add a new Timeline using PivotTable as data source
        Parameters:
        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:
        The new add Timeline index

      • add

        function add(pivot, destCellName, baseFieldIndex)
        Add a new Timeline using PivotTable as data source
        Parameters:
        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:
        The new add Timeline index

      • add

        function add(pivot, row, column, baseField)
        Add a new Timeline using PivotTable as data source
        Parameters:
        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:
        The new add Timeline index

      • add

        function add(pivot, destCellName, baseField)
        Add a new Timeline using PivotTable as data source
        Parameters:
        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

      • clear

        function clear()

      • removeAt

        function removeAt(index)

      • iterator

        function iterator()

      • get

        function get(index)
        Reserved for internal use.

      • contains

        function contains(value)
        Reserved for internal use.

      • add

        function add(value)
        Reserved for internal use.

      • indexOf

        function indexOf(value)
        Reserved for internal use.