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.setDataTableShown(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()
methodsetAutoScaleFont(value)
           True if the text in the object changes font size when the object size changes. The default value is True.
methodgetBackground()
methodsetBackground(value)
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
methodgetBackgroundMode()
methodsetBackgroundMode(value)
           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()
methodsetHasBorderHorizontal(value)
           True if the chart data table has horizontal cell borders
methodhasBorderOutline()
methodsetHasBorderOutline(value)
           True if the chart data table has outline borders
methodhasBorderVertical()
methodsetHasBorderVertical(value)
           True if the chart data table has vertical cell borders
methodgetShowLegendKey()
methodsetShowLegendKey(value)
           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

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.