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)→ inherited from CollectionBase
          Reserved for internal use.
methodclear()→ inherited from CollectionBase
          
methodcontains(value)→ inherited from CollectionBase
          Reserved for internal use.
methodget(index)→ inherited from CollectionBase
          Reserved for internal use.
methodindexOf(value)→ inherited from CollectionBase
          Reserved for internal use.
methoditerator()→ inherited from CollectionBase
          
methodremoveAt(index)→ inherited from CollectionBase
          
 

Property Getters/Setters Detail

getCount : int 

int getCount()

get : Trendline 

Trendline get(index)
Gets a object by its index.
See Also:
Trendline

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.

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.