Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
Modifier and Type | Method and Description |
---|---|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule.
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1) |
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1,
java.lang.String formula2)
A factory method allowing to create a conditional formatting rule
with a cell comparison operator
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(ExtendedColor color) |
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(HSSFExtendedColor color)
Create a Databar conditional formatting rule.
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)
A factory method allowing the creation of conditional formatting
rules using an Icon Set / Multi-State formatting.
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(java.lang.String formula)
A factory method allowing to create a conditional formatting rule with a formula.
The formatting rules are applied by Excel when the value of the formula not equal to 0. |
HSSFConditionalFormattingRule |
HSSFConditionalFormatting.getRule(int idx) |
Modifier and Type | Method and Description |
---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1) |
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule[] cfRules)
Allows to add a new Conditional Formatting set to the sheet.
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1,
HSSFConditionalFormattingRule rule2) |
void |
HSSFConditionalFormatting.addRule(HSSFConditionalFormattingRule cfRule)
add a Conditional Formatting rule.
|
void |
HSSFConditionalFormatting.setRule(int idx,
HSSFConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx.
|
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.