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 | ||
---|---|---|
method | getCount() | |
method | get(index) | |
Gets a object by its index. |
Method Summary | ||
---|---|---|
method | add(type) | |
Adds a object to this collection with specified type. | ||
method | add(type, name) | |
Adds a object to this collection with specified type and name. | ||
method | add(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | clear() | → inherited from CollectionBase |
method | contains(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | get(index) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | indexOf(value) | → inherited from CollectionBase |
Reserved for internal use. | ||
method | iterator() | → inherited from CollectionBase |
method | removeAt(index) | → inherited from CollectionBase |
Property Getters/Setters Detail |
---|
getCount : int | |
int getCount() |
get : Trendline | |
Trendline get(index) |
Method Detail |
---|
add | |
int add(type) |
type: int
- A add | |
int add(type, name) |
type: int
- A name: String
- Trendline name.clear | |
clear() |
removeAt | |
removeAt(index) |
iterator | |
Iterator iterator() |
get | |
Object get(index) |
contains | |
boolean contains(value) |
add | |
int add(value) |
indexOf | |
int indexOf(value) |