ConditionalFormattingIconCollection

Inheritance: java.lang.Object, com.aspose.cells.CollectionBase

public class ConditionalFormattingIconCollection extends CollectionBase

Represents a collection of ConditionalFormattingIcon objects.

Example

         //Instantiating a Workbook object
         Workbook workbook = new Workbook();
 
         Worksheet sheet = workbook.getWorksheets().get(0);
 
         //Get Conditional Formatting
         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);
 
         //Sets condition
          int idx = fcs.addCondition(FormatConditionType.ICON_SET);
 
          FormatCondition cond = fcs.get(idx);
 
          //Sets condition's type
          cond.getIconSet().setType(IconSetType.ARROWS_GRAY_3);
 
         //Add custom iconset condition.
          ConditionalFormattingIcon cfIcon = cond.getIconSet().getCfIcons().get(0);
 
          cfIcon.setType(IconSetType.ARROWS_3);
 
          cfIcon.setIndex(0);
 
          ConditionalFormattingIcon cfIcon1 = cond.getIconSet().getCfIcons().get(1);
 
           cfIcon1.setType(IconSetType.ARROWS_GRAY_3);
 
           cfIcon1.setIndex(1);
 
           ConditionalFormattingIcon cfIcon2 = cond.getIconSet().getCfIcons().get(2);
 
           cfIcon2.setType(IconSetType.BOXES_5);
 
           cfIcon2.setIndex(2);
 
         //Saving the Excel file
         workbook.save("output.xls");

Methods

MethodDescription
add(ConditionalFormattingIcon cficon)Adds ConditionalFormattingIcon object.
add(int type, int index)Adds ConditionalFormattingIcon object.
add(Object o)Adds an item to the CollectionBase instance.
clear()Removes all objects from the CollectionBase instance.
contains(Object o)Return whether instance contains this object
equals(Object arg0)
get(int index)Gets the ConditionalFormattingIcon element at the specified index.
getClass()
getCount()Gets the number of elements contained in the CollectionBase instance.
hashCode()
indexOf(Object o)Determines the index of a specific item in the CollectionBase instance.
iterator()Returns an enumerator that iterates through the CollectionBase instance.
notify()
notifyAll()
removeAt(int index)Removes the item at the specified index.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

add(ConditionalFormattingIcon cficon)

public int add(ConditionalFormattingIcon cficon)

Adds ConditionalFormattingIcon object.

Parameters:

ParameterTypeDescription
cficonConditionalFormattingIconReturns the index of new object in the list.

Returns: int

add(int type, int index)

public int add(int type, int index)

Adds ConditionalFormattingIcon object.

Parameters:

ParameterTypeDescription
typeintIconSetType. The value type.
indexintThe Index.

Returns: int - Returns the index of new object in the list.

add(Object o)

public int add(Object o)

Adds an item to the CollectionBase instance.

Parameters:

ParameterTypeDescription
ojava.lang.ObjectThe Object to add to the CollectionBase instance.

Returns: int - The position into which the new element was inserted.

clear()

public void clear()

Removes all objects from the CollectionBase instance.

contains(Object o)

public boolean contains(Object o)

Return whether instance contains this object

Parameters:

ParameterTypeDescription
ojava.lang.Objecttest object

Returns: boolean - Whether instance contains this object

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

get(int index)

public ConditionalFormattingIcon get(int index)

Gets the ConditionalFormattingIcon element at the specified index.

Parameters:

ParameterTypeDescription
indexintThe zero based index of the element.

Returns: ConditionalFormattingIcon - The element at the specified index.

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getCount()

public int getCount()

Gets the number of elements contained in the CollectionBase instance.

Returns: int - The number of elements contained in the CollectionBase instance.

hashCode()

public native int hashCode()

Returns: int

indexOf(Object o)

public int indexOf(Object o)

Determines the index of a specific item in the CollectionBase instance.

Parameters:

ParameterTypeDescription
ojava.lang.ObjectDetermines the index of a specific item in the CollectionBase instance.

Returns: int - The index of value if found in the list; otherwise, -1.

iterator()

public Iterator iterator()

Returns an enumerator that iterates through the CollectionBase instance.

Returns: java.util.Iterator - An iterator for the CollectionBase instance.

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

removeAt(int index)

public void removeAt(int index)

Removes the item at the specified index.

Parameters:

ParameterTypeDescription
indexintThe zero-based index of the item to remove.

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int