public final class HSSFSheetConditionalFormatting extends java.lang.Object implements SheetConditionalFormatting
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(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1) |
int |
addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule[] cfRules)
Allows to add a new Conditional Formatting set to the sheet.
(允许向工作表添加新的条件格式集。)
|
int |
addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule rule1, HSSFConditionalFormattingRule rule2) |
int |
addConditionalFormatting(ConditionalFormatting cf)
Adds a copy of a ConditionalFormatting object to the sheet
(将 ConditionalFormatting 对象的副本添加到工作表)
|
int |
addConditionalFormatting(HSSFConditionalFormatting cf)
Adds a copy of HSSFConditionalFormatting object to the sheet
(将 HSSFConditionalFormatting 对象的副本添加到工作表)
|
HSSFConditionalFormattingRule |
createConditionalFormattingColorScaleRule()
Create a Color Scale / Color Gradient conditional formatting rule.
(创建色标/颜色渐变条件格式规则。)
|
HSSFConditionalFormattingRule |
createConditionalFormattingRule(byte comparisonOperation, java.lang.String formula1)
Create a conditional formatting rule that compares a cell value to a formula calculated result, using an operator *
(创建条件格式规则,将单元格值与公式计算结果进行比较,使用运算符 *)
|
HSSFConditionalFormattingRule |
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 |
createConditionalFormattingRule(ExtendedColor color)
Create a Databar conditional formatting rule.
(创建数据栏条件格式规则。)
|
HSSFConditionalFormattingRule |
createConditionalFormattingRule(HSSFExtendedColor color)
Create a Databar conditional formatting rule.
(创建数据栏条件格式规则。)
|
HSSFConditionalFormattingRule |
createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)
A factory method allowing the creation of conditional formatting rules using an Icon Set / Multi-State formatting.
(允许使用图标集/多状态格式创建条件格式规则的工厂方法。)
|
HSSFConditionalFormattingRule |
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. (允许使用公式创建条件格式规则的工厂方法。当公式的值不等于 0 时,Excel 将应用格式规则。) |
HSSFConditionalFormatting |
getConditionalFormattingAt(int index)
gets Conditional Formatting object at a particular index
(获取特定索引处的条件格式对象)
|
int |
getNumConditionalFormattings() |
void |
removeConditionalFormatting(int index)
removes a Conditional Formatting object by index
(按索引删除条件格式对象)
|
public HSSFConditionalFormattingRule 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
CFRuleBase.ComparisonOperator.BETWEEN
) and
CFRuleBase.ComparisonOperator.NOT_BETWEEN
operations)
(formula2 - - 第二个公式(仅与 CFRuleBase.ComparisonOperator.BETWEEN 和 CFRuleBase.ComparisonOperator.NOT_BETWEEN 操作一起使用))
public HSSFConditionalFormattingRule createConditionalFormattingRule(byte comparisonOperation, java.lang.String formula1)
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)
formula1
- the formula to determine if the conditional formatting is applied
(formula1 - 确定是否应用条件格式的公式)
public HSSFConditionalFormattingRule createConditionalFormattingRule(java.lang.String formula)
TODO - formulas containing cell references are currently not parsed properly
(允许使用公式创建条件格式规则的工厂方法。当公式的值不等于 0 时,Excel 将应用格式规则。 TODO - 包含单元格引用的公式当前未正确解析)createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
formula
- - formula for the valued, compared with the cell
(公式 - - 值的公式,与单元格比较)
public HSSFConditionalFormattingRule createConditionalFormattingRule(IconMultiStateFormatting.IconSet iconSet)
HSSFConditionalFormattingRule.getMultiStateFormatting()
then
HSSFIconMultiStateFormatting.getThresholds()
(允许使用图标集/多状态格式创建条件格式规则的工厂方法。它的阈值将被创建,但将为空,需要使用 HSSFConditionalFormattingRule.getMultiStateFormatting() 然后 HSSFIconMultiStateFormatting.getThresholds() 进行配置)
createConditionalFormattingRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingRule)
public HSSFConditionalFormattingRule createConditionalFormattingRule(HSSFExtendedColor color)
The thresholds and colour for it will be created, but will be empty and require configuring with HSSFConditionalFormattingRule.getDataBarFormatting()
then HSSFDataBarFormatting.getMinThreshold()
and HSSFDataBarFormatting.getMaxThreshold()
public HSSFConditionalFormattingRule 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 HSSFConditionalFormattingRule createConditionalFormattingColorScaleRule()
The thresholds and colours for it will be created, but will be empty and require configuring with HSSFConditionalFormattingRule.getColorScaleFormatting()
then HSSFColorScaleFormatting.getThresholds()
and HSSFColorScaleFormatting.getColors()
createConditionalFormattingColorScaleRule
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 createConditionalFormattingColorScaleRule)
public int addConditionalFormatting(HSSFConditionalFormatting 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);)
cf
- HSSFConditionalFormatting object
(cf - HSSFConditionalFormatting 对象)
public int addConditionalFormatting(ConditionalFormatting cf)
SheetConditionalFormatting
This method could be used to copy ConditionalFormatting object from one sheet to another. For example:
ConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);(将 ConditionalFormatting 对象的副本添加到工作表 此方法可用于将 ConditionalFormatting 对象从一个工作表复制到另一个工作表。例如:ConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);)
addConditionalFormatting
in interface
SheetConditionalFormatting
(接口 SheetConditionalFormatting 中的 addConditionalFormatting)
cf
- the Conditional Formatting to clone
(cf - 要克隆的条件格式)
public int addConditionalFormatting(CellRangeAddress[] regions, HSSFConditionalFormattingRule[] cfRules)
regions
- - list of rectangular regions to apply conditional formatting rules
(区域 - 应用条件格式规则的矩形区域列表)
cfRules
- - set of up to three conditional formatting rules
(cfRules - - 最多三个条件格式规则的集合)
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, HSSFConditionalFormattingRule rule1)
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, HSSFConditionalFormattingRule rule1, HSSFConditionalFormattingRule rule2)
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 HSSFConditionalFormatting 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.