asposecells.api

asposecells.api

Class TrendlineCollection

Represents a collection of all the Trendline objects for the specified data series.

Example:

excel = Workbook()
chartIndex = excel.getWorksheets().get(0).getCharts().add(ChartType.COLUMN, 3, 3, 15, 10)
chart = excel.getWorksheets().get(0).getCharts().get(chartIndex)
chart.getNSeries().add("A1:a3", True)
chart.getNSeries().get(0).getTrendLines().add(TrendlineType.LINEAR, "MyTrendLine")
line = chart.getNSeries().get(0).getTrendLines().get(0)
line.setDisplayEquation(True)
line.setDisplayRSquared(True)
line.setColor(Color.getRed())

Property Getters/Setters Summary
methodgetCount()
methodget(index)
Gets a object by its index.
 
Method Summary
methodadd(type)
Adds a object to this collection with specified type.
methodadd(type, name)
Adds a object to this collection with specified type and name.
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(type)
        Adds a object to this collection with specified type.
        Parameters:
        type: int - A TrendlineType value. Trendline type.
        Returns:
        Trendline object index.
        See Also:
        Trendline

      • add

        int add(type, name)
        Adds a object to this collection with specified type and name.
        Parameters:
        type: int - A TrendlineType value. Trendline type.
        name: String - Trendline name.
        Returns:
        Trendline object index.
        See Also:
        Trendline

      • 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.