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 Trendline object by its index.
 
Method Summary
methodadd(type)
Adds a Trendline object to this collection with specified type.
methodadd(type, name)
Adds a Trendline 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 Trendline object to this collection with specified type.
        Parameters:
        type: int - A TrendlineType value. Trendline type.
        Returns:
        Trendline object index.

      • add

        int add(type, name)
        Adds a Trendline 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.

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