asposecells.api

Property Getters/Setters Detail

• getType/setType : int 

  int getType() / setType(value)
  

  Represents error bar amount type. The value of the property is ErrorBarType integer constant.

  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)
  

  Represents error bar display type. The value of the property is ErrorBarDisplayType integer constant.

• getAmount/setAmount : float 

  float getAmount() / setAmount(value)
  

  Represents amount of error bar. The amount must be greater than and equal to zero.

• getShowMarkerTTop/setShowMarkerTTop : boolean 

  boolean getShowMarkerTTop() / setShowMarkerTTop(value)
  

  Indicates if formatting error bars with a T-top.

• getPlusValue/setPlusValue : String 

  String getPlusValue() / setPlusValue(value)
  

  Represents positive error amount when error bar type is Custom.

• getMinusValue/setMinusValue : String 

  String getMinusValue() / setMinusValue(value)
  

  Represents negative error amount when error bar type is Custom.

• getCompoundType/setCompoundType : int 

  int getCompoundType() / setCompoundType(value)
  

  Specifies the compound line type The value of the property is MsoLineStyle integer constant.

• getDashType/setDashType : int 

  int getDashType() / setDashType(value)
  

  Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.

• getCapType/setCapType : int 

  int getCapType() / setCapType(value)
  

  Specifies the ending caps. The value of the property is LineCapType integer constant.

• getJoinType/setJoinType : int 

  int getJoinType() / setJoinType(value)
  

  Specifies the joining caps. The value of the property is LineJoinType integer constant.

• getBeginType/setBeginType : int 

  int getBeginType() / setBeginType(value)
  

  Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.

• getEndType/setEndType : int 

  int getEndType() / setEndType(value)
  

  Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.

• getBeginArrowLength/setBeginArrowLength : int 

  int getBeginArrowLength() / setBeginArrowLength(value)
  

  Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.

• getEndArrowLength/setEndArrowLength : int 

  int getEndArrowLength() / setEndArrowLength(value)
  

  Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.

• getBeginArrowWidth/setBeginArrowWidth : int 

  int getBeginArrowWidth() / setBeginArrowWidth(value)
  

  Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.

• getEndArrowWidth/setEndArrowWidth : int 

  int getEndArrowWidth() / setEndArrowWidth(value)
  

  Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.

• getThemeColor/setThemeColor : ThemeColor 

  ThemeColor getThemeColor() / setThemeColor(value)
  

  Gets and sets the theme color.

  If the foreground color is not a theme color, NULL will be returned.

• getColor/setColor : Color 

  Color getColor() / setColor(value)
  

  Represents the com.aspose.cells.Color of the line.

• getTransparency/setTransparency : float 

  float getTransparency() / setTransparency(value)
  

  Returns or sets the degree of transparency of the line as a value from 0.0 (opaque) through 1.0 (clear).

• getStyle/setStyle : int 

  int getStyle() / setStyle(value)
  

  Represents the style of the line. The value of the property is LineType integer constant.

• getWeight/setWeight : int 

  int getWeight() / setWeight(value)
  

  Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.

• getWeightPt/setWeightPt : float 

  float getWeightPt() / setWeightPt(value)
  

  Gets or sets the weight of the line in unit of points.

• getWeightPx/setWeightPx : float 

  float getWeightPx() / setWeightPx(value)
  

  Gets or sets the weight of the line in unit of pixels.

• getFormattingType/setFormattingType : int 

  int getFormattingType() / setFormattingType(value)
  

  Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.

• isAutomaticColor : boolean 

  boolean isAutomaticColor()
  

  Indicates whether the color of line is automatic assigned.

• isVisible/setVisible : boolean 

  boolean isVisible() / setVisible(value)
  

  Represents whether the line is visible.

• isAuto/setAuto : boolean 

  boolean isAuto() / setAuto(value)
  

  Indicates whether this line style is auto assigned.

• getGradientFill : GradientFill 

  GradientFill getGradientFill()
  

  Represents gradient fill.