asposecells.api

Class ChartPointCollection

Represents a collection that contains all the points in one series.

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)
points = chart.getNSeries().get(0).getPoints()
for i in range(0, points.getCount()):
    # Get Data Point
    point = points.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
methodgetCount()
Gets the count of the chart point.
methodget(index)
Gets the ChartPoint element at the specified index in the series.
 
Method Summary
methodclear()
Remove all setting of the chart points.
methoditerator()
Returns an enumerator for the entire ChartPointCollection.
methodremoveAt(index)
Removes point at the index of the series..
 

    • Property Getters/Setters Detail

      • getCount : int 

        int getCount()
        
        Gets the count of the chart point.
      • get : ChartPoint 

        ChartPoint get(index)
        
        Gets the ChartPoint element at the specified index in the series.
        Parameters:
        index - The index of chart point in the series.
        Returns:
        The ChartPoint object.
    • Method Detail

      • iterator

        Iterator iterator()
        Returns an enumerator for the entire ChartPointCollection.
        Returns:
      • clear

         clear()
        Remove all setting of the chart points.
      • removeAt

         removeAt(index)
        Removes point at the index of the series..
        Parameters:
        index: int - The index of the point.