Namespace EasyXLS

Class ExcelConditionalFormatting

System.Object
EasyXLS.ExcelConditionalFormatting

public class ExcelConditionalFormatting extends System.Object
This class stores the conditional formatting information like cells range and conditions.
  • Constructor Summary

    Constructors
    Constructor
    Description
    Defines an instance of the conditional formatting.
    ExcelConditionalFormatting​(int firstRow, int firstColumn, int lastRow, int lastColumn, List lstConditions)
    Defines an instance of the conditional formatting having the specified range.
    ExcelConditionalFormatting​(System.String range, int nOperator, System.String firstFormula, System.String secondFormula)
    Defines an instance of the conditional formatting having the specified position, operator and formula restrictions.
    ExcelConditionalFormatting​(System.String range, int nOperator, System.String firstFormula, System.String secondFormula, bool isBold, bool isItalic, System.Drawing.Color foreground)
    Defines an instance of the conditional formatting having the specified position, operator, formula restrictions and font settings.
    ExcelConditionalFormatting​(System.String range, int nOperator, System.String firstFormula, System.String secondFormula, bool isBold, bool isItalic, System.Drawing.Color foreground, System.Drawing.Color background)
    Defines an instance of the conditional formatting having the specified position, operator, formula restrictions, font settings and background.
    ExcelConditionalFormatting​(System.String range, int nOperator, System.String firstFormula, System.String secondFormula, System.Drawing.Color background)
    Defines an instance of the conditional formatting having the specified position, operator, formula restrictions and background.
    ExcelConditionalFormatting​(System.String range, List lstConditions)
    Defines an instance of the conditional formatting on the specified range.
  • Method Summary

    Modifier and Type
    Method
    Description
    void
    addCondition​(int nOperator, System.String firstFormula, System.String secondFormula)
    Adds a new condition with the specified operation and formula restrictions.
    This method is overridden as addCondition_2 in COM+ version of EasyXLS.
    void
    addCondition​(int nOperator, System.String firstFormula, System.String secondFormula, bool isBold, bool isItalic, System.Drawing.Color foreground)
    Adds a new condition with the specified operation, formula restrictions and font settings.
    This method is overridden as addCondition_3 in COM+ version of EasyXLS.
    void
    addCondition​(int nOperator, System.String firstFormula, System.String secondFormula, bool isBold, bool isItalic, System.Drawing.Color foreground, System.Drawing.Color background)
    Adds a new condition with the specified operation, formula restrictions, font settings and background.
    This method is overridden as addCondition_4 in COM+ version of EasyXLS.
    void
    addCondition​(int nOperator, System.String firstFormula, System.String secondFormula, System.Drawing.Color background)
    Adds a new condition with the specified operation, formula restrictions, background.
    This method is overridden as addCondition_5 in COM+ version of EasyXLS.
    void
    Adds a new condition.
    Creates and returns a copy of this object.
    int
    Returns the number of conditions.
    getConditionAt​(int index)
    Returns the condition with the specified index.
    int
    Returns the first column index of the cells range.
    int
    Returns the first row index of the cells range.
    int
    Returns the last column index of the cells range.
    int
    Returns the last row index of the cells range.
    System.String
    Returns the range where the conditional formatting will be aplied.
    void
    insertCondition​(int index, ExcelCondition condition)
    Inserts a new condition.
    void
    removeCondition​(int index)
    Removes the condition with the specified index.
    void
    setFirstColumn​(int firstColumn)
    Sets the first column of the cell range where the conditional formatting will be applied.
    void
    setFirstRow​(int firstRow)
    Sets the first row of the cell range where the conditional formatting will be applied.
    void
    setLastColumn​(int lastColumn)
    Sets the last column of the cell range where the conditional formatting will be applied.
    void
    setLastRow​(int lastRow)
    Sets the last row of the cell range where the conditional formatting will be applied.
    void
    setRange​(int firstRow, int firstColumn, int lastRow, int lastColumn)
    Sets the range where the conditional formatting is applied.
    void
    setRange​(System.String range)
    Sets the range where the conditional formatting is applied.
    This method is overridden as setRange_2 in COM+ version of EasyXLS.

    Methods inherited from class System.Object

    equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait