Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.ss.usermodel | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Class | Description |
---|---|---|
class |
HSSFConditionalFormattingRule |
High level representation of Conditional Formatting Rule.
|
Modifier and Type | Method | Description |
---|---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1) |
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules) |
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2) |
|
void |
HSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule) |
|
void |
HSSFConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule) |
Modifier and Type | Method | Description |
---|---|---|
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula) |
Create a conditional formatting rule that compares a cell value
to a formula calculated result, using an operator *
|
ConditionalFormattingRule |
SheetConditionalFormatting.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
|
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(java.lang.String formula) |
Create a conditional formatting rule based on a Boolean formula.
|
ConditionalFormattingRule |
ConditionalFormatting.getRule(int idx) |
Modifier and Type | Method | Description |
---|---|---|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule) |
Add a new Conditional Formatting to the sheet.
|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules) |
Add a new Conditional Formatting set to the sheet.
|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2) |
Add a new Conditional Formatting consisting of two rules.
|
void |
ConditionalFormatting.addRule(ConditionalFormattingRule cfRule) |
Add a Conditional Formatting rule.
|
void |
ConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule) |
Replaces an existing Conditional Formatting rule at position idx.
|
Modifier and Type | Class | Description |
---|---|---|
class |
XSSFConditionalFormattingRule |
Modifier and Type | Method | Description |
---|---|---|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1) |
|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules) |
|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2) |
|
void |
XSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule) |
Add a Conditional Formatting rule.
|
void |
XSSFConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule) |
Replaces an existing Conditional Formatting rule at position idx.
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.