asposecells.api

Classes

Constants

Class ChartPoint

Represents a single point in a series in a chart.

Example:

# Instantiating a Workbook object
workbook = Workbook()
# Obtaining the reference of the first worksheet
worksheet = workbook.getWorksheets().get(0)

# Adding a sample value to "A1" cell
worksheet.getCells().get("A1").putValue(50)
# Adding a sample value to "A2" cell
worksheet.getCells().get("A2").putValue(100)
# Adding a sample value to "A3" cell
worksheet.getCells().get("A3").putValue(150)
# Adding a sample value to "B1" cell
worksheet.getCells().get("B1").putValue(60)
# Adding a sample value to "B2" cell
worksheet.getCells().get("B2").putValue(32)
# Adding a sample value to "B3" cell
worksheet.getCells().get("B3").putValue(50)

# Adding a chart to the worksheet
chartIndex = worksheet.getCharts().add(ChartType.PIE_EXPLODED, 5, 0, 25, 10)
# Accessing the instance of the newly added chart
chart = worksheet.getCharts().get(chartIndex)
# Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
chart.getNSeries().add("A1:B3", True)
# Show Data Labels 
chart.getNSeries().get(0).getDataLabels().setShowValue(True)
for i in range(0, chart.getNSeries().get(0).getPoints().getCount()):
    # Get Data Point
    point = chart.getNSeries().get(0).getPoints().get(i)
    # Set Pir Explosion
    point.setExplosion(15)
    # Set Border Color
    point.getBorder().setColor(Color.getRed())

# Saving the Excel file
workbook.save("Book1.xls")

Property Getters/Setters Summary
`method`	`getArcEndPointXPx()`
	Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
`method`	`getArcEndPointYPx()`
	Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
`method`	`getArcStartPointXPx()`
	Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
`method`	`getArcStartPointYPx()`
	Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
`method`	`getArea()`
	Gets the Area.
`method`	`getBorder()`
	Gets the Line.
`method`	`getBorderWidthPx()`
	Gets the width of border in units of pixels after calls Chart.Calculate() method.
`method`	`getDataLabels()`
	Returns a DataLabels object that represents the data label associated with this chart point.
`method`	`getEndAngle()`
	Gets the ending angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart.
`method`	`getExplosion()`
`method`	`setExplosion(value)`
	The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.
`method`	`getInnerArcEndPointXPx()`
	Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
`method`	`getInnerArcEndPointYPx()`
	Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
`method`	`getInnerArcStartPointXPx()`
	Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
`method`	`getInnerArcStartPointYPx()`
	Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
`method`	`getInnerRadiusPx()`
	Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method. Applies to Doughnut chart.
`method`	`isInSecondaryPlot()`
`method`	`setInSecondaryPlot(value)`
	Gets or sets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart
`method`	`getMarker()`
	Gets the Marker.
`method`	`getRadiusPx()`
	Gets the radius of bubble, pie or doughnut in units of pixels after calls Chart.Calculate() method.
`method`	`getShadow()`
`method`	`setShadow(value)`
	True if the chartpoint has a shadow.
`method`	`getShapeHeight()`
	Gets the height in units of 1/4000 of chart's height after calls Chart.Calculate() method.
`method`	`getShapeHeightPx()`
	Gets the height in units of pixels after calls Chart.Calculate() method.
`method`	`getShapeProperties()`
	Gets the ShapePropertyCollection object that holds the visual shape properties of the ChartPoint.
`method`	`getShapeWidth()`
	Gets the width in units of 1/4000 of chart's width after calls Chart.Calculate() method.
`method`	`getShapeWidthPx()`
	Gets the width in units of pixels after calls Chart.Calculate() method.
`method`	`getShapeX()`
	Gets the x coordinate of the upper left corner in units of 1/4000 of chart's width after calls Chart.Calculate() method.
`method`	`getShapeXPx()`
	Gets the x coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
`method`	`getShapeY()`
	Gets the y coordinate of the upper left corner in units of 1/4000 of chart's height after calls Chart.Calculate() method.
`method`	`getShapeYPx()`
	Gets the y coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
`method`	`getStartAngle()`
	Gets the starting angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart.
`method`	`getXValue()`
`method`	`setXValue(value)`
	Gets or sets the X value of the chart point.
`method`	`getXValueType()`
	Gets X value type of the chart point. The value of the property is CellValueType integer constant.
`method`	`getYValue()`
`method`	`setYValue(value)`
	Gets or sets the Y value of the chart point.
`method`	`getYValueType()`
	Gets Y value type of the chart point. The value of the property is CellValueType integer constant.

Method Summary
`method`	`getBottomPointCount()`
`method`	Gets the number of bottom points after calls Chart.Calculate() method.
`method`	`getBottomPointXPx(index)`
`method`	Gets x-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid
`method`	`getBottomPointYPx(index)`
`method`	Gets y-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid
`method`	`getOnCategoryAxisPointCount()`
`method`	Gets the number of the points on category axis after calls Chart.Calculate() method. Only applies to area chart.
`method`	`getOnCategoryAxisPointXPx(index)`
`method`	Gets x-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Area chart.
`method`	`getOnCategoryAxisPointYPx(index)`
`method`	Gets y-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Area chart.
`method`	`getTopPointCount()`
`method`	Gets the number of top points after calls Chart.Calculate() method.
`method`	`getTopPointXPx(index)`
`method`	Gets x-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D
`method`	`getTopPointYPx(index)`
`method`	Gets y-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D

- Property Getters/Setters Detail
  - getExplosion/setExplosion : int
```
int getExplosion() / setExplosion(value)
```
    The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.
  - getShadow/setShadow : boolean
```
boolean getShadow() / setShadow(value)
```
    True if the chartpoint has a shadow.
  - getBorder : Line
```
Line getBorder()
```
    Gets the Line.
  - getArea : Area
```
Area getArea()
```
    Gets the Area.
  - getMarker : Marker
```
Marker getMarker()
```
    Gets the Marker.
  - getDataLabels : DataLabels
```
DataLabels getDataLabels()
```
    Returns a DataLabels object that represents the data label associated with this chart point.
  - getYValue/setYValue : Object
```
Object getYValue() / setYValue(value)
```
    Gets or sets the Y value of the chart point.
  - getYValueType : int
```
int getYValueType()
```
    Gets Y value type of the chart point. The value of the property is CellValueType integer constant.
  - getXValue/setXValue : Object
```
Object getXValue() / setXValue(value)
```
    Gets or sets the X value of the chart point.
  - getXValueType : int
```
int getXValueType()
```
    Gets X value type of the chart point. The value of the property is CellValueType integer constant.
  - getShapeProperties : ShapePropertyCollection
```
ShapePropertyCollection getShapeProperties()
```
    Gets the ShapePropertyCollection object that holds the visual shape properties of the ChartPoint.
  - isInSecondaryPlot/setInSecondaryPlot : boolean
```
boolean isInSecondaryPlot() / setInSecondaryPlot(value)
```
    Gets or sets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart
  - getShapeX : int
```
int getShapeX()
```
    Gets the x coordinate of the upper left corner in units of 1/4000 of chart's width after calls Chart.Calculate() method.
  - getShapeY : int
```
int getShapeY()
```
    Gets the y coordinate of the upper left corner in units of 1/4000 of chart's height after calls Chart.Calculate() method.
  - getShapeWidth : int
```
int getShapeWidth()
```
    Gets the width in units of 1/4000 of chart's width after calls Chart.Calculate() method.
  - getShapeHeight : int
```
int getShapeHeight()
```
    Gets the height in units of 1/4000 of chart's height after calls Chart.Calculate() method.
  - getShapeXPx : int
```
int getShapeXPx()
```
    Gets the x coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
  - getShapeYPx : int
```
int getShapeYPx()
```
    Gets the y coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
  - getShapeWidthPx : int
```
int getShapeWidthPx()
```
    Gets the width in units of pixels after calls Chart.Calculate() method.
  - getShapeHeightPx : int
```
int getShapeHeightPx()
```
    Gets the height in units of pixels after calls Chart.Calculate() method.
  - getBorderWidthPx : int
```
int getBorderWidthPx()
```
    Gets the width of border in units of pixels after calls Chart.Calculate() method.
  - getRadiusPx : int
```
int getRadiusPx()
```
    Gets the radius of bubble, pie or doughnut in units of pixels after calls Chart.Calculate() method.
  - getInnerRadiusPx : int
```
int getInnerRadiusPx()
```
    Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method. Applies to Doughnut chart.
  - getStartAngle : float
```
float getStartAngle()
```
    Gets the starting angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart.
  - getEndAngle : float
```
float getEndAngle()
```
    Gets the ending angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method. Applies to Pie chart.
  - getArcStartPointXPx : float
```
float getArcStartPointXPx()
```
    Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
  - getArcStartPointYPx : float
```
float getArcStartPointYPx()
```
    Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
  - getArcEndPointXPx : float
```
float getArcEndPointXPx()
```
    Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
  - getArcEndPointYPx : float
```
float getArcEndPointYPx()
```
    Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Pie and Doughnut chart.
  - getInnerArcStartPointXPx : float
```
float getInnerArcStartPointXPx()
```
    Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
  - getInnerArcStartPointYPx : float
```
float getInnerArcStartPointYPx()
```
    Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
  - getInnerArcEndPointXPx : float
```
float getInnerArcEndPointXPx()
```
    Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
  - getInnerArcEndPointYPx : float
```
float getInnerArcEndPointYPx()
```
    Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method. Applies to Doughnut chart.
- Method Detail
  - getTopPointCount
```
int getTopPointCount()
```
    Gets the number of top points after calls Chart.Calculate() method.
  - getTopPointXPx
```
float getTopPointXPx(index)
```
    Gets x-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D
  - getTopPointYPx
```
float getTopPointYPx(index)
```
    Gets y-coordinate of the top point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D
  - getBottomPointCount
```
int getBottomPointCount()
```
    Gets the number of bottom points after calls Chart.Calculate() method.
  - getBottomPointXPx
```
float getBottomPointXPx(index)
```
    Gets x-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid
  - getBottomPointYPx
```
float getBottomPointYPx(index)
```
    Gets y-coordinate of the bottom point of shape after calls Chart.Calculate() method. Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid
  - getOnCategoryAxisPointCount
```
int getOnCategoryAxisPointCount()
```
    Gets the number of the points on category axis after calls Chart.Calculate() method. Only applies to area chart.
    Area 2D chart return 1 Area 3D chart return 2.
  - getOnCategoryAxisPointXPx
```
float getOnCategoryAxisPointXPx(index)
```
    Gets x-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Area chart.
    Area 2D chart: index is 0. Area 3D chart: index is 0 or 1.
  - getOnCategoryAxisPointYPx
```
float getOnCategoryAxisPointYPx(index)
```
    Gets y-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Area chart.
    Area 2D chart: index is 0. Area 3D chart: index is 0 or 1.

asposecells.api

Classes

Constants

Class ChartPoint

Property Getters/Setters Detail

getExplosion/setExplosion : int

getShadow/setShadow : boolean

getBorder : Line

getArea : Area

getMarker : Marker

getDataLabels : DataLabels

getYValue/setYValue : Object

getYValueType : int

getXValue/setXValue : Object

getXValueType : int

getShapeProperties : ShapePropertyCollection

isInSecondaryPlot/setInSecondaryPlot : boolean

getShapeX : int

getShapeY : int

getShapeWidth : int

getShapeHeight : int

getShapeXPx : int

getShapeYPx : int

getShapeWidthPx : int

getShapeHeightPx : int

getBorderWidthPx : int

getRadiusPx : int

getInnerRadiusPx : int

getStartAngle : float

getEndAngle : float

getArcStartPointXPx : float

getArcStartPointYPx : float

getArcEndPointXPx : float

getArcEndPointYPx : float

getInnerArcStartPointXPx : float

getInnerArcStartPointYPx : float

getInnerArcEndPointXPx : float

getInnerArcEndPointYPx : float

Method Detail

getTopPointCount

getTopPointXPx

getTopPointYPx

getBottomPointCount

getBottomPointXPx

getBottomPointYPx

getOnCategoryAxisPointCount

getOnCategoryAxisPointXPx

getOnCategoryAxisPointYPx