asposecells.api

asposecells.api

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
methodgetCount()
methodget(index)
Gets the Timeline by index.
methodget(name)
Gets the Timeline by Timeline's name.
 
Method Summary
methodadd(pivot, row, column, baseField)
Add a new Timeline using PivotTable as data source
methodadd(pivot, row, column, baseFieldIndex)
Add a new Timeline using PivotTable as data source
methodadd(pivot, row, column, baseFieldName)
Add a new Timeline using PivotTable as data source
methodadd(pivot, destCellName, baseField)
Add a new Timeline using PivotTable as data source
methodadd(pivot, destCellName, baseFieldIndex)
Add a new Timeline using PivotTable as data source
methodadd(pivot, destCellName, baseFieldName)
Add a new Timeline using PivotTable as data source
methodadd(value)
Reserved for internal use.
methodclear()
methodcontains(value)
Reserved for internal use.
methodget(index)
Reserved for internal use.
methodindexOf(value)
Reserved for internal use.
methoditerator()
methodremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : int 

        int getCount()

    • Method Detail

      • add

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

        int 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

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

        int 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: int - The index of PivotField in PivotTable.BaseFields
        Returns:
        The new add Timeline index

      • add

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

        int 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

         clear()

      • removeAt

         removeAt(index)

      • iterator

        Iterator iterator()

      • get

        Object get(index)
        Reserved for internal use.

      • contains

        boolean contains(value)
        Reserved for internal use.

      • add

        int add(value)
        Reserved for internal use.

      • indexOf

        int indexOf(value)
        Reserved for internal use.