com.aspose.cells
Class ConditionalFormattingCollection
java.lang.Object
CollectionBase
com.aspose.cells.ConditionalFormattingCollection
- All Implemented Interfaces:
- java.lang.Iterable
public class ConditionalFormattingCollection
- extends CollectionBase
Encapsulates a collection of FormatCondition objects.
Example:
//Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
//Get Conditional Formattings
ConditionalFormattingCollection cformattings = sheet.getConditionalFormattings();
//Adds an empty conditional formatting
int index = cformattings.add();
//Get newly added Conditional formatting
FormatConditionCollection fcs = cformattings.get(index);
//Sets the conditional format range.
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.EndRow = 0;
ca.StartColumn = 0;
ca.EndColumn = 0;
fcs.addArea(ca);
ca = new CellArea();
ca.StartRow = 1;
ca.EndRow = 1;
ca.StartColumn = 1;
ca.EndColumn = 1;
fcs.addArea(ca);
//Add condition.
int conditionIndex = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "=A2", "100");
//Add condition.
int conditionIndex2 = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "50", "100");
//Sets the background color.
FormatCondition fc = fcs.get(conditionIndex);
fc.getStyle().setBackgroundColor(Color.getRed());
//Saving the Excel file
workbook.save("C:\\output.xls");
Property Getters/Setters Detail |
-
-
Gets the FormatConditions element at the specified index.
- Parameters:
index
- The zero based index of the element.
removeArea | |
public void removeArea(int startRow, int startColumn, int totalRows, int totalColumns) |
-
Remove all conditional formattings in the range.
- Parameters:
startRow
- The start row of the range.startColumn
- The start column of the range.totalRows
- The number of rows of the range.totalColumns
- The number of columns of the range.
-
Copies condtional formattings.
- Parameters:
cfs
- The condtional formattings
-
Adds a FormatConditions to the collection.
- Returns:
- FormatConditions object index.
-
removeAt | → inherited from CollectionBase |
public void removeAt(int index) |
-
iterator | → inherited from CollectionBase |
public java.util.Iterator iterator() |
-
get | → inherited from CollectionBase |
public java.lang.Object get(int index) |
- Reserved for internal use.
contains | → inherited from CollectionBase |
public boolean contains(java.lang.Object value) |
- Reserved for internal use.
add | → inherited from CollectionBase |
public int add(java.lang.Object value) |
- Reserved for internal use.
indexOf | → inherited from CollectionBase |
public int indexOf(java.lang.Object value) |
- Reserved for internal use.
See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.