Example:
workbook = Workbook()
cells = workbook.getWorksheets().get(0).getCells()
cells.get("a1").putValue(2)
cells.get("a2").putValue(5)
cells.get("a3").putValue(3)
cells.get("a4").putValue(6)
cells.get("b1").putValue(4)
cells.get("b2").putValue(3)
cells.get("b3").putValue(6)
cells.get("b4").putValue(7)
chartIndex = workbook.getWorksheets().get(0).getCharts().add(ChartType.COLUMN, 11, 0, 27, 10)
chart = workbook.getWorksheets().get(0).getCharts().get(chartIndex)
chart.getNSeries().add("A1:B4", True)
# Applying a dotted line style on the lines of an NSeries
chart.getNSeries().get(0).getBorder().setStyle(LineType.DOT)
# Applying a triangular marker style on the data markers of an NSeries
chart.getNSeries().get(0).getMarker().setMarkerStyle(ChartMarkerType.TRIANGLE)
# Setting the weight of all lines in an NSeries to medium
chart.getNSeries().get(0).getBorder().setWeight(WeightType.MEDIUM_LINE)
| Property Getters/Setters Summary | ||
|---|---|---|
method | getBeginArrowLength() | |
method | setBeginArrowLength(value) | |
| Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant. | ||
method | getBeginArrowWidth() | |
method | setBeginArrowWidth(value) | |
| Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant. | ||
method | getBeginType() | |
method | setBeginType(value) | |
| Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant. | ||
method | getCapType() | |
method | setCapType(value) | |
| Specifies the ending caps. The value of the property is LineCapType integer constant. | ||
method | getColor() | |
method | setColor(value) | |
|
Represents the |
||
method | getCompoundType() | |
method | setCompoundType(value) | |
| Specifies the compound line type The value of the property is MsoLineStyle integer constant. | ||
method | getDashType() | |
method | setDashType(value) | |
| Specifies the dash line type The value of the property is MsoLineDashStyle integer constant. | ||
method | getEndArrowLength() | |
method | setEndArrowLength(value) | |
| Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant. | ||
method | getEndArrowWidth() | |
method | setEndArrowWidth(value) | |
| Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant. | ||
method | getEndType() | |
method | setEndType(value) | |
| Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant. | ||
method | getFormattingType() | |
method | setFormattingType(value) | |
| Gets or sets format type. The value of the property is ChartLineFormattingType integer constant. | ||
method | getGradientFill() | |
Represents gradient fill.
|
||
method | isAuto() | |
method | setAuto(value) | |
| Indicates whether this line style is auto assigned. | ||
method | isAutomaticColor() | |
Indicates whether the color of line is automatic assigned.
|
||
method | isVisible() | |
method | setVisible(value) | |
| Represents whether the line is visible. | ||
method | getJoinType() | |
method | setJoinType(value) | |
| Specifies the joining caps. The value of the property is LineJoinType integer constant. | ||
method | getStyle() | |
method | setStyle(value) | |
| Represents the style of the line. The value of the property is LineType integer constant. | ||
method | getThemeColor() | |
method | setThemeColor(value) | |
| Gets and sets the theme color. | ||
method | getTransparency() | |
method | setTransparency(value) | |
| Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear). | ||
method | getWeight() | |
method | setWeight(value) | |
|
Gets or sets the |
||
method | getWeightPt() | |
method | setWeightPt(value) | |
| Gets or sets the weight of the line in unit of points. | ||
method | getWeightPx() | |
method | setWeightPx(value) | |
| Gets or sets the weight of the line in unit of pixels. | ||
int getCompoundType() / setCompoundType(value)
int getDashType() / setDashType(value)
int getCapType() / setCapType(value)
int getJoinType() / setJoinType(value)
int getBeginType() / setBeginType(value)
int getEndType() / setEndType(value)
int getBeginArrowLength() / setBeginArrowLength(value)
int getEndArrowLength() / setEndArrowLength(value)
int getBeginArrowWidth() / setBeginArrowWidth(value)
int getEndArrowWidth() / setEndArrowWidth(value)
ThemeColor getThemeColor() / setThemeColor(value)
Color getColor() / setColor(value)
float getTransparency() / setTransparency(value)
int getStyle() / setStyle(value)
int getWeight() / setWeight(value)
float getWeightPt() / setWeightPt(value)
float getWeightPx() / setWeightPx(value)
int getFormattingType() / setFormattingType(value)
boolean isAutomaticColor()
boolean isVisible() / setVisible(value)
boolean isAuto() / setAuto(value)
GradientFill getGradientFill()