public class XSSFSheetConditionalFormatting extends java.lang.Object implements SheetConditionalFormatting
Modifier and Type | Field and Description |
---|---|
protected static java.lang.String |
CF_EXT_2009_NS_X14
Office 2010 Conditional Formatting extensions namespace
(Office 2010 条件格式扩展命名空间)
|
Modifier and Type | Method and Description |
---|---|
int |
addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1)
Add a new Conditional Formatting to the sheet.
(向工作表添加新的条件格式。)
|
int |
addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)
Add a new Conditional Formatting set to the sheet.
(将新的条件格式集添加到工作表。)
|
int |
addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)
Add a new Conditional Formatting consisting of two rules.
(添加由两条规则组成的新条件格式。)
|
int |
addConditionalFormatting(ConditionalFormatting cf)
Adds a copy of HSSFConditionalFormatting object to the sheet
(将 HSSFConditionalFormatting 对象的副本添加到工作表)
|
XSSFConditionalFormattingRule |
createConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule.
(创建色标/颜色渐变条件格式规则。)
|
XSSFConditionalFormattingRule |
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 *
(创建条件格式规则,将单元格值与公式计算结果进行比较,使用运算符 *)
|
XSSFConditionalFormattingRule |
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
(允许使用单元格比较运算符创建条件格式规则的工厂方法)
|
XSSFConditionalFormattingRule |
createConditionalFormattingRule(ExtendedColor color)
Create a Databar conditional formatting rule.
(创建数据栏条件格式规则。)
|
XSSFConditionalFormattingRule |
createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)
A factory method allowing the creation of conditional formatting rules using an Icon Set / Multi-State formatting.
(允许使用图标集/多状态格式创建条件格式规则的工厂方法。)
|
XSSFConditionalFormattingRule |
createConditionalFormattingRule(java.lang.String formula)
A factory method allowing to create a conditional formatting rule with a formula.
(允许使用公式创建条件格式规则的工厂方法。) |
XSSFConditionalFormattingRule |
createConditionalFormattingRule(XSSFColor color)
Create a Databar conditional formatting rule.
(创建数据栏条件格式规则。)
|
XSSFConditionalFormatting |
getConditionalFormattingAt(int index)
gets Conditional Formatting object at a particular index
(获取特定索引处的条件格式对象)
|
int |
getNumConditionalFormattings() |
void |
removeConditionalFormatting(int index)
removes a Conditional Formatting object by index
(按索引删除条件格式对象)
|
protected static final java.lang.String CF_EXT_2009_NS_X14
public XSSFConditionalFormattingRule createConditionalFormattingRule(byte comparisonOperation, java.lang.String formula1, java.lang.String formula2)
TODO - formulas containing cell references are currently not parsed properly
(允许使用单元格比较运算符 TODO 创建条件格式规则的工厂方法 - 当前未正确解析包含单元格引用的公式)createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
comparisonOperation
- - a constant value from
CFRuleBase.ComparisonOperator
:
formula1
- - formula for the valued, compared with the cell
(formula1 - - 值的公式,与单元格比较)
formula2
- - second formula (only used with
ComparisonOperator.BETWEEN
) and
ComparisonOperator.NOT_BETWEEN
operations)
(formula2 - - 第二个公式(仅与ComparisonOperator.BETWEEN 和ComparisonOperator.NOT_BETWEEN 操作一起使用))
public XSSFConditionalFormattingRule createConditionalFormattingRule(byte comparisonOperation, java.lang.String formula)
SheetConditionalFormatting
The type of the created condition is ConditionType.CELL_VALUE_IS
createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
comparisonOperation
- MUST be a constant value from
ComparisonOperator
except BETWEEN and NOT_BETWEEN
(compareOperation - 必须是来自 ComparisonOperator 的常量值,除了 BETWEEN 和 NOT_BETWEEN)
formula
- the formula to determine if the conditional formatting is applied
(公式 - 确定是否应用条件格式的公式)
public XSSFConditionalFormattingRule createConditionalFormattingRule(java.lang.String formula)
createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
formula
- - formula for the valued, compared with the cell
(公式 - - 值的公式,与单元格比较)
public XSSFConditionalFormattingRule createConditionalFormattingRule(XSSFColor color)
The thresholds and colour for it will be created, but will be empty and require configuring with XSSFConditionalFormattingRule.getDataBarFormatting()
then XSSFDataBarFormatting.getMinThreshold()
and XSSFDataBarFormatting.getMaxThreshold()
public XSSFConditionalFormattingRule createConditionalFormattingRule(ExtendedColor color)
SheetConditionalFormatting
The thresholds and colour for it will be created, but will be empty and require configuring with ConditionalFormattingRule.getDataBarFormatting()
then DataBarFormatting.getMinThreshold()
and DataBarFormatting.getMaxThreshold()
createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
public XSSFConditionalFormattingRule createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)
XSSFConditionalFormattingRule.getMultiStateFormatting()
then
XSSFIconMultiStateFormatting.getThresholds()
(允许使用图标集/多状态格式创建条件格式规则的工厂方法。它的阈值将被创建,但将为空,需要使用 XSSFConditionalFormattingRule.getMultiStateFormatting() 然后 XSSFIconMultiStateFormatting.getThresholds() 进行配置)
createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
public XSSFConditionalFormattingRule createConditionalFormattingColorScaleRule()
The thresholds and colours for it will be created, but will be empty and require configuring with XSSFConditionalFormattingRule.getColorScaleFormatting()
then XSSFColorScaleFormatting.getThresholds()
and XSSFColorScaleFormatting.getColors()
createConditionalFormattingColorScaleRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingColorScaleRule)
public int addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule[] cfRules)
SheetConditionalFormatting
addConditionalFormatting
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 addConditionalFormatting)
regions
- - list of rectangular regions to apply conditional formatting rules
(区域 - 应用条件格式规则的矩形区域列表)
cfRules
- - set of up to conditional formatting rules (max 3 for Excel pre-2007)
(cfRules - - 最多设置条件格式规则(Excel pre-2007 最多 3 个))
public int addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1)
SheetConditionalFormatting
addConditionalFormatting
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 addConditionalFormatting)
regions
- - list of rectangular regions to apply conditional formatting rules
(区域 - 应用条件格式规则的矩形区域列表)
rule1
- - the rule to apply
(rule1 - - 要应用的规则)
public int addConditionalFormatting(CellRangeAddress[] regions, ConditionalFormattingRule rule1, ConditionalFormattingRule rule2)
SheetConditionalFormatting
addConditionalFormatting
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 addConditionalFormatting)
regions
- - list of rectangular regions to apply conditional formatting rules
(区域 - 应用条件格式规则的矩形区域列表)
rule1
- - the first rule
(rule1 - - 第一条规则)
rule2
- - the second rule
(rule2 - - 第二条规则)
public int addConditionalFormatting(ConditionalFormatting cf)
This method could be used to copy HSSFConditionalFormatting object from one sheet to another. For example:
HSSFConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);(将 HSSFConditionalFormatting 对象的副本添加到工作表 此方法可用于将 HSSFConditionalFormatting 对象从一个工作表复制到另一个工作表。例如:HSSFConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);)
addConditionalFormatting
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 addConditionalFormatting)
cf
- HSSFConditionalFormatting object
(cf - HSSFConditionalFormatting 对象)
public XSSFConditionalFormatting getConditionalFormattingAt(int index)
getConditionalFormattingAt
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 getConditionalFormattingAt)
index
- of the Conditional Formatting object to fetch
(index - 要获取的条件格式对象)
public int getNumConditionalFormattings()
getNumConditionalFormattings
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 getNumConditionalFormattings)
public void removeConditionalFormatting(int index)
removeConditionalFormatting
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 removeConditionalFormatting)
index
- of a Conditional Formatting object to remove
(index - 要删除的条件格式对象)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.