asposecells.api

Class ChartDataTable

Represents a chart data table.

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.COLUMN, 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)
chart.setShowDataTable(True)
# Getting Chart Table
chartTable = chart.getChartDataTable()
# Setting Chart Table Font Color
chartTable.getFont().setColor(Color.getRed())
# Setting Legend Key Visibility
chartTable.setShowLegendKey(False)
# Saving the Excel file
workbook.save("Book1.xls")

Property Getters/Setters Summary
methodgetAutoScaleFont()
method
           True if the text in the object changes font size when the object size changes. The default value is True.
methodgetBackground()
method
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
methodgetBackgroundMode()
method
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
methodgetBorder()
Returns a Border object that represents the border of the object
methodgetFont()
Gets a Font object which represents the font setting of the specified chart data table.
methodhasBorderHorizontal()
method
           True if the chart data table has horizontal cell borders
methodhasBorderOutline()
method
           True if the chart data table has outline borders
methodhasBorderVertical()
method
           True if the chart data table has vertical cell borders
methodgetShowLegendKey()
method
           True if the data label legend key is visible.
 

    • Property Getters/Setters Detail

      • getFont : Font 

        Font getFont()
        
        Gets a Font object which represents the font setting of the specified chart data table.
      • getAutoScaleFont/setAutoScaleFont : boolean 

        boolean getAutoScaleFont() / setAutoScaleFont(value)
        
        True if the text in the object changes font size when the object size changes. The default value is True.
      • getBackgroundMode/setBackgroundMode : int 

        int getBackgroundMode() / setBackgroundMode(value)
        
        Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
      • getBackground/setBackground : int 

        int getBackground() / setBackground(value)
        
        Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.NOTE: This member is now obsolete. Instead, please use ChartDataTable.BackgroundMode property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.
      • hasBorderHorizontal/setHasBorderHorizontal : boolean 

        boolean hasBorderHorizontal() / setHasBorderHorizontal(value)
        
        True if the chart data table has horizontal cell borders
      • hasBorderVertical/setHasBorderVertical : boolean 

        boolean hasBorderVertical() / setHasBorderVertical(value)
        
        True if the chart data table has vertical cell borders
      • hasBorderOutline/setHasBorderOutline : boolean 

        boolean hasBorderOutline() / setHasBorderOutline(value)
        
        True if the chart data table has outline borders
      • getShowLegendKey/setShowLegendKey : boolean 

        boolean getShowLegendKey() / setShowLegendKey(value)
        
        True if the data label legend key is visible.
      • getBorder : Line 

        Line getBorder()
        
        Returns a Border object that represents the border of the object