com.aspose.cells

Class ChartDataTable

  • java.lang.Object
    • com.aspose.cells.ChartDataTable
public class ChartDataTable 
extends java.lang.Object

Represents a chart data table.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the first worksheet
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
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 25, 10);

//Accessing the instance of the newly added chart
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
ChartDataTable chartTable = chart.getChartDataTable();

//Setting Chart Table Font Color
chartTable.getFont().setColor(com.aspose.cells.Color.getRed());

//Setting Legend Key Visibility
chartTable.setShowLegendKey(false);

//Saving the Excel file
workbook.save("D:\\book1.xls");

Property Getters/Setters Summary
booleangetAutoScaleFont()
void
setAutoScaleFont(booleanvalue)
           True if the text in the object changes font size when the object size changes. The default value is True.
intgetBackground()
void
setBackground(intvalue)
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
intgetBackgroundMode()
void
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
LinegetBorder()
Returns a Border object that represents the border of the object
FontgetFont()
Gets a Font object which represents the font setting of the specified chart data table.
booleanhasBorderHorizontal()
void
           True if the chart data table has horizontal cell borders
booleanhasBorderOutline()
void
setHasBorderOutline(booleanvalue)
           True if the chart data table has outline borders
booleanhasBorderVertical()
void
setHasBorderVertical(booleanvalue)
           True if the chart data table has vertical cell borders
booleangetShowLegendKey()
void
setShowLegendKey(booleanvalue)
           True if the data label legend key is visible.
 

    • Property Getters/Setters Detail

      • getFont

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

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

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

        public int getBackground() / public void setBackground(int 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

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

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

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

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

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

    setAutoScaleFont

    public voidsetAutoScaleFont(booleanvalue)
    
    True if the text in the object changes font size when the object size changes. The default value is True.

    setBackgroundMode

    public voidsetBackgroundMode(intvalue)
    
    Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.

    setBackground

    public voidsetBackground(intvalue)
    
    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.

    setHasBorderHorizontal

    public voidsetHasBorderHorizontal(booleanvalue)
    
    True if the chart data table has horizontal cell borders

    setHasBorderVertical

    public voidsetHasBorderVertical(booleanvalue)
    
    True if the chart data table has vertical cell borders

    setHasBorderOutline

    public voidsetHasBorderOutline(booleanvalue)
    
    True if the chart data table has outline borders

    setShowLegendKey

    public voidsetShowLegendKey(booleanvalue)
    
    True if the data label legend key is visible.