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).getLine().setStyle(LineType.DOT) # Applying a triangular marker style on the data markers of an NSeries chart.getNSeries().get(0).setMarkerStyle(ChartMarkerType.TRIANGLE) # Setting the weight of all lines in an NSeries to medium chart.getNSeries().get(0).getLine().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 auotmatic 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 uni of pixels. |
Property Getters/Setters Detail |
---|
getCompoundType/setCompoundType : int | |
int getCompoundType() / setCompoundType(value) |
getDashType/setDashType : int | |
int getDashType() / setDashType(value) |
getCapType/setCapType : int | |
int getCapType() / setCapType(value) |
getJoinType/setJoinType : int | |
int getJoinType() / setJoinType(value) |
getBeginType/setBeginType : int | |
int getBeginType() / setBeginType(value) |
getEndType/setEndType : int | |
int getEndType() / setEndType(value) |
getBeginArrowLength/setBeginArrowLength : int | |
int getBeginArrowLength() / setBeginArrowLength(value) |
getEndArrowLength/setEndArrowLength : int | |
int getEndArrowLength() / setEndArrowLength(value) |
getBeginArrowWidth/setBeginArrowWidth : int | |
int getBeginArrowWidth() / setBeginArrowWidth(value) |
getEndArrowWidth/setEndArrowWidth : int | |
int getEndArrowWidth() / setEndArrowWidth(value) |
getThemeColor/setThemeColor : ThemeColor | |
ThemeColor getThemeColor() / setThemeColor(value) |
getColor/setColor : Color | |
Color getColor() / setColor(value) |
getTransparency/setTransparency : float | |
float getTransparency() / setTransparency(value) |
getStyle/setStyle : int | |
int getStyle() / setStyle(value) |
getWeight/setWeight : int | |
int getWeight() / setWeight(value) |
getWeightPt/setWeightPt : float | |
float getWeightPt() / setWeightPt(value) |
getWeightPx/setWeightPx : float | |
float getWeightPx() / setWeightPx(value) |
getFormattingType/setFormattingType : int | |
int getFormattingType() / setFormattingType(value) |
isAutomaticColor : boolean | |
boolean isAutomaticColor() |
isVisible/setVisible : boolean | |
boolean isVisible() / setVisible(value) |
isAuto/setAuto : boolean | |
boolean isAuto() / setAuto(value) |
getGradientFill : GradientFill | |
GradientFill getGradientFill() |