Property Getters/Setters Summary | ||
---|---|---|
method | getBackgroundColor() | |
method | setBackgroundColor(value) | |
Gets or sets the background |
||
method | getBorder() | |
method | setBorder(value) | |
Gets or sets the border |
||
method | getCenterX() | |
Gets the x coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's width after calls Chart.Calculate() method. | ||
method | getCenterXPx() | |
Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method. | ||
method | getCenterY() | |
Gets the y coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's height after calls Chart.Calculate() method. | ||
method | getCenterYPx() | |
Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method. | ||
method | getDepth() | |
Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method. | ||
method | getDepthPx() | |
Gets the depth front to back in units of pixels after calls Chart.Calculate() method. | ||
method | getFillFormat() | |
Represents a object that contains fill formatting properties for the specified chart or shape. | ||
method | getForegroundColor() | |
method | setForegroundColor(value) | |
Gets or sets the foreground |
||
method | getFormatting() | |
method | setFormatting(value) | |
Represents the formatting of the area. The value of the property is FormattingType integer constant. | ||
method | getHeight() | |
Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method. | ||
method | getHeightPx() | |
Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method. | ||
method | getInvertIfNegative() | |
method | setInvertIfNegative(value) | |
If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged. | ||
method | getTransparency() | |
method | setTransparency(value) | |
Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). | ||
method | getWidth() | |
Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method. | ||
method | getWidthPx() | |
Gets the width of left to right in units of pixels after calls Chart.Calculate() method. |
Method Summary | ||
---|---|---|
method | getCubePointCount() | |
Gets the number of cube points after calls Chart.Calculate() method. | ||
method | getCubePointXPx(index) | |
Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of walls cube is eight | ||
method | getCubePointYPx(index) | |
Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of walls cube is eight. | ||
method | isAuto() | → inherited from Area |
method | isVisible() | → inherited from Area |
method | setAuto(isAuto) | → inherited from Area |
Property Getters/Setters Detail |
---|
getCenterX : int | |
int getCenterX() |
getCenterY : int | |
int getCenterY() |
getWidth : int | |
int getWidth() |
getDepth : int | |
int getDepth() |
getHeight : int | |
int getHeight() |
getCenterXPx : int | |
int getCenterXPx() |
getCenterYPx : int | |
int getCenterYPx() |
getWidthPx : int | |
int getWidthPx() |
getDepthPx : int | |
int getDepthPx() |
getHeightPx : int | |
int getHeightPx() |
getBorder/setBorder : Line | |
Line getBorder() / setBorder(value) |
getBackgroundColor/setBackgroundColor : Color | |
Color getBackgroundColor() / setBackgroundColor(value) |
getForegroundColor/setForegroundColor : Color | |
Color getForegroundColor() / setForegroundColor(value) |
getFormatting/setFormatting : int | |
int getFormatting() / setFormatting(value) |
getInvertIfNegative/setInvertIfNegative : boolean | |
boolean getInvertIfNegative() / setInvertIfNegative(value) |
Example:
# Instantiating a Workbook object workbook = Workbook() # Adding a new worksheet to the Workbook object sheetIndex = workbook.getWorksheets().add() # Obtaining the reference of the newly added worksheet by passing its sheet index worksheet = workbook.getWorksheets().get(sheetIndex) # 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 chart to the worksheet chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 15, 5) # 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 "A3" chart.getNSeries().add("A1:A3", True) chart.getNSeries().get(0).getArea().setInvertIfNegative(True) # Setting the foreground color of the 1st NSeries area chart.getNSeries().get(0).getArea().setForegroundColor(Color.getRed()) # Setting the background color of the 1st NSeries area. # The displayed area color of second chart point will be the background color. chart.getNSeries().get(0).getArea().setBackgroundColor(Color.getYellow()) # Saving the Excel file workbook.save("Book1.xls")
getFillFormat : FillFormat | |
FillFormat getFillFormat() |
getTransparency/setTransparency : float | |
float getTransparency() / setTransparency(value) |
Method Detail |
---|
getCubePointCount | |
int getCubePointCount() |
getCubePointXPx | |
float getCubePointXPx(index) |
getCubePointYPx | |
float getCubePointYPx(index) |
isAuto | |
boolean isAuto() |
isVisible | |
boolean isVisible() |
setAuto | |
setAuto(isAuto) |