Java org.apache.poi.ss.usermodel SheetConditionalFormatting fields, constructors, methods, implement or subclass

Example usage for Java org.apache.poi.ss.usermodel SheetConditionalFormatting fields, constructors, methods, implement or subclass

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. SheetConditionalFormatting

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.ss.usermodel SheetConditionalFormatting.

The text is from its open source code.

Method

intaddConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule)
Add a new Conditional Formatting to the sheet.
intaddConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)
Add a new Conditional Formatting set to the sheet.
intaddConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)
Add a new Conditional Formatting consisting of two rules.
ConditionalFormattingRulecreateConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule.
ConditionalFormattingRulecreateConditionalFormattingRule(String formula)
Create a conditional formatting rule based on a Boolean formula.
ConditionalFormattingRulecreateConditionalFormattingRule(ExtendedColor color)
Create a Databar conditional formatting rule.
ConditionalFormattingRulecreateConditionalFormattingRule(IconSet iconSet)
Create an Icon Set / Multi-State conditional formatting rule.
ConditionalFormattingRulecreateConditionalFormattingRule(byte comparisonOperation, String formula)
Create a conditional formatting rule that compares a cell value to a formula calculated result, using an operator

The type of the created condition is ConditionType#CELL_VALUE_IS

ConditionalFormattingRulecreateConditionalFormattingRule(byte comparisonOperation, String formula1, String formula2)
A factory method allowing to create a conditional formatting rule with a cell comparison operator

The created conditional formatting rule compares a cell value to a formula calculated result, using the specified operator.

ConditionalFormattinggetConditionalFormattingAt(int index)
Gets Conditional Formatting object at a particular index
intgetNumConditionalFormattings()
voidremoveConditionalFormatting(int index)
Removes a Conditional Formatting object by index