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) cells.get("C1").putValue("Q1") cells.get("C2").putValue("Q2") cells.get("C3").putValue("Y1") cells.get("C4").putValue("Y2") 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) chart.getNSeries().setCategoryData("C1:C4") for i in range(0, chart.getNSeries().getCount()): aseries = chart.getNSeries().get(i) aseries.getXErrorBar().setDisplayType(ErrorBarDisplayType.MINUS) aseries.getXErrorBar().setType(ErrorBarType.FIXED_VALUE) aseries.getXErrorBar().setAmount(5)
Property Getters/Setters Summary | ||
---|---|---|
method | getAmount() | |
method | setAmount(value) | |
Represents amount of error bar.
|
||
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 | getDisplayType() | |
method | setDisplayType(value) | |
Represents error bar display type. The value of the property is ErrorBarDisplayType 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 | getMinusValue() | |
method | setMinusValue(value) | |
Represents negative error amount when error bar type is InnerCustom. | ||
method | getPlusValue() | |
method | setPlusValue(value) | |
Represents positive error amount when error bar type is InnerCustom. | ||
method | getShowMarkerTTop() | |
method | setShowMarkerTTop(value) | |
Indicates if formatting error bars with a T-top. | ||
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 | getType() | |
method | setType(value) | |
Represents error bar amount type. The value of the property is ErrorBarType integer constant. | ||
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 |
---|
getType/setType : int | |
int getType() / setType(value) |
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) cells.get("C1").putValue("Q1") cells.get("C2").putValue("Q2") cells.get("C3").putValue("Y1") cells.get("C4").putValue("Y2") 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) chart.getNSeries().setCategoryData("C1:C4") for i in range (0, chart.getNSeries().getCount()): aseries = chart.getNSeries().get(i) # Sets custom error bar type aseries.getXErrorBar().setType(ErrorBarType.CUSTOM) aseries.getXErrorBar().setPlusValue("=Sheet1!A1") aseries.getXErrorBar().setMinusValue("=Sheet1!A2")
getDisplayType/setDisplayType : int | |
int getDisplayType() / setDisplayType(value) |
getAmount/setAmount : float | |
float getAmount() / setAmount(value) |
getShowMarkerTTop/setShowMarkerTTop : boolean | |
boolean getShowMarkerTTop() / setShowMarkerTTop(value) |
getPlusValue/setPlusValue : String | |
String getPlusValue() / setPlusValue(value) |
getMinusValue/setMinusValue : String | |
String getMinusValue() / setMinusValue(value) |
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() |