public class TrendlineCollection
Example:
int chartIndex = excel.getWorksheets().get(0).getCharts().add(ChartType.COLUMN, 3, 3, 15, 10); Chart chart = excel.getWorksheets().get(0).getCharts().get(chartIndex); chart.getNSeries().add("A1:a3", true); chart.getNSeries().get(0).getTrendLines().add(TrendlineType.LINEAR, "MyTrendLine"); Trendline line = chart.getNSeries().get(0).getTrendLines().get(0); line.setDisplayEquation(true); line.setDisplayRSquared(true); line.setColor(Color.getRed());
Property Getters/Setters Summary | ||
---|---|---|
int | getCount() | |
Trendline | get(int index) | |
Gets a object by its index.
|
Method Summary | ||
---|---|---|
int | add(int type) | |
Adds a object to this collection with specified type.
|
||
int | add(int type, java.lang.String name) | |
Adds a object to this collection with specified type and name.
|
||
int | add(java.lang.Object value) | |
Reserved for internal use. |
||
void | clear() | |
boolean | contains(java.lang.Object value) | |
Reserved for internal use. |
||
int | indexOf(java.lang.Object value) | |
Reserved for internal use. |
||
java.util.Iterator | iterator() | |
void | removeAt(int index) | |
public int add(int type)
type
- A public int add(int type, java.lang.String name)
type
- A name
- Trendline name.public void clear()
public void removeAt(int index)
public java.util.Iterator iterator()
public boolean contains(java.lang.Object value)
public int add(java.lang.Object value)
public int indexOf(java.lang.Object value)