public class DataBar
Example:
//Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
//Adds an empty conditional formatting
int index = sheet.getConditionalFormattings().add();
FormatConditionCollection fcs = sheet.getConditionalFormattings().get(index);
//Sets the conditional format range.
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.EndRow = 2;
ca.StartColumn = 0;
ca.EndColumn = 0;
fcs.addArea(ca);
//Adds condition.
int idx = fcs.addCondition(FormatConditionType.DATA_BAR);
fcs.addArea(ca);
FormatCondition cond = fcs.get(idx);
//Get Databar
DataBar dataBar = cond.getDataBar();
dataBar.setColor(Color.getOrange());
//Set Databar properties
dataBar.getMinCfvo().setType(FormatConditionValueType.PERCENTILE);
dataBar.getMinCfvo().setValue(30);
dataBar.setShowValue(false);
//Put Cell Values
sheet.getCells().get("A1").putValue(10);
sheet.getCells().get("A2").putValue(120);
sheet.getCells().get("A3").putValue(260);
| Property Getters/Setters Summary | ||
|---|---|---|
com.aspose.cells.Color | getAxisColor() | |
void | setAxisColor(com.aspose.cells.Colorvalue) | |
| Gets the color of the axis for cells with conditional formatting as data bars. | ||
int | getAxisPosition() | |
void | setAxisPosition(intvalue) | |
| Gets or sets the position of the axis of the data bars specified by a conditional formatting rule. The value of the property is DataBarAxisPosition integer constant. | ||
DataBarBorder | getBarBorder() | |
Gets an object that specifies the border of a data bar.
|
||
int | getBarFillType() | |
void | setBarFillType(intvalue) | |
| Gets or sets how a data bar is filled with color. The value of the property is DataBarFillType integer constant. | ||
com.aspose.cells.Color | getColor() | |
void | setColor(com.aspose.cells.Colorvalue) | |
| Get or set this DataBar's Color. | ||
int | getDirection() | |
void | setDirection(intvalue) | |
| Gets or sets the direction the databar is displayed. The value of the property is TextDirectionType integer constant. | ||
ConditionalFormattingValue | getMaxCfvo() | |
Get or set this DataBar's max value object.
Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
|
||
int | getMaxLength() | |
void | setMaxLength(intvalue) | |
| Represents the max length of data bar . | ||
ConditionalFormattingValue | getMinCfvo() | |
Get or set this DataBar's min value object.
Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
|
||
int | getMinLength() | |
void | setMinLength(intvalue) | |
| Represents the min length of data bar . | ||
NegativeBarFormat | getNegativeBarFormat() | |
Gets the NegativeBarFormat object associated with a data bar conditional formatting rule.
|
||
boolean | getShowValue() | |
void | setShowValue(booleanvalue) | |
| Get or set the flag indicating whether to show the values of the cells on which this data bar is applied. Default value is true. | ||
| Method Summary | ||
|---|---|---|
byte[] | toImage(Cell cell, ImageOrPrintOptions imgOpts) | |
Render data bar in cell to image byte array.
|
||
public com.aspose.cells.Color getAxisColor() / public void setAxisColor(com.aspose.cells.Color value)
public int getAxisPosition() / public void setAxisPosition(int value)
public int getBarFillType() / public void setBarFillType(int value)
public int getDirection() / public void setDirection(int value)
public DataBarBorder getBarBorder()
public NegativeBarFormat getNegativeBarFormat()
public ConditionalFormattingValue getMinCfvo()
public ConditionalFormattingValue getMaxCfvo()
public com.aspose.cells.Color getColor() / public void setColor(com.aspose.cells.Color value)
public int getMinLength() / public void setMinLength(int value)
public int getMaxLength() / public void setMaxLength(int value)
public boolean getShowValue() / public void setShowValue(boolean value)
public byte[] toImage(Cell cell, ImageOrPrintOptions imgOpts) throws java.lang.Exception
cell - Indicate the data bar in which cell to be renderedimgOpts - ImageOrPrintOptions contains some property of output image