public final class HSSFConditionalFormatting extends java.lang.Object implements ConditionalFormatting
HSSFConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);
HSSFSheet.getSheetConditionalFormatting()
to get access to an instance of this class.
To create a new Conditional Formatting set use the following approach:
// Define a Conditional Formatting rule, which triggers formatting // when cell's value is greater or equal than 100.0 and // applies patternFormatting defined below. HSSFConditionalFormattingRule rule = sheet.createConditionalFormattingRule( ComparisonOperator.GE, "100.0", // 1st formula null // 2nd formula is not used for comparison operator GE ); // Create pattern with red background HSSFPatternFormatting patternFmt = rule.cretePatternFormatting(); patternFormatting.setFillBackgroundColor(HSSFColor.RED.index); // Define a region containing first column Region [] regions = { new Region(1,(short)1,-1,(short)1) }; // Apply Conditional Formatting rule defined above to the regions sheet.addConditionalFormatting(regions, rule);(HSSFConditionalFormatting 类封装了条件格式的所有设置。该类可用于复制 HSSFConditionalFormatting 设置。例如:HSSFConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);或修改现有的条件格式设置(格式化区域和/或规则)。使用 HSSFSheet.getSheetConditionalFormatting() 来访问此类的实例。要创建新的条件格式集,请使用以下方法: // 定义条件格式规则,当单元格的值大于或等于 100.0 时触发格式化 // 并应用下面定义的 patternFormatting。 HSSFConditionalFormattingRule rule = sheet.createConditionalFormattingRule(ComparisonOperator.GE, "100.0", // 第一个公式 null // 第二个公式不用于比较运算符 GE ); // 创建带有红色背景的图案 HSSFPatternFormatting patternFmt = rule.cretePatternFormatting(); patternFormatting.setFillBackgroundColor(HSSFColor.RED.index); // 定义一个包含第一列的区域 Region [] region = { new Region(1,(short)1,-1,(short)1) }; // 将上面定义的条件格式规则应用到区域 sheet.addConditionalFormatting(regions, rule);)
Modifier and Type | Method and Description |
---|---|
void |
addRule(ConditionalFormattingRule cfRule)
Add a Conditional Formatting rule.
(添加条件格式规则。)
|
void |
addRule(HSSFConditionalFormattingRule cfRule)
add a Conditional Formatting rule.
(添加条件格式规则。)
|
CellRangeAddress[] |
getFormattingRanges() |
int |
getNumberOfRules() |
HSSFConditionalFormattingRule |
getRule(int idx) |
void |
setFormattingRanges(CellRangeAddress[] ranges)
Sets the cell ranges the rule conditional formatting must be applied to.
(设置必须应用规则条件格式的单元格范围。)
|
void |
setRule(int idx, ConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx.
(替换位置 idx 处的现有条件格式规则。)
|
void |
setRule(int idx, HSSFConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx.
(替换位置 idx 处的现有条件格式规则。)
|
java.lang.String |
toString() |
public CellRangeAddress[] getFormattingRanges()
getFormattingRanges
in interface
ConditionalFormatting
(接口 ConditionalFormatting 中的 getFormattingRanges)
null
(CellRangeAddresss 数组。从不为空)
public void setFormattingRanges(CellRangeAddress[] ranges)
ConditionalFormatting
setFormattingRanges
in interface
ConditionalFormatting
(接口 ConditionalFormatting 中的 setFormattingRanges)
ranges
- non-null array of
CellRangeAddresss
(范围 - CellRangeAddresss 的非空数组)
public void setRule(int idx, HSSFConditionalFormattingRule cfRule)
idx
- position of the rule. Should be between 0 and 2 for older Excel versions
(idx - 规则的位置。对于旧版 Excel,应介于 0 和 2 之间)
cfRule
- - Conditional Formatting rule
(cfRule - - 条件格式规则)
public void setRule(int idx, ConditionalFormattingRule cfRule)
ConditionalFormatting
setRule
in interface
ConditionalFormatting
(接口 ConditionalFormatting 中的 setRule)
idx
- position of the rule. Should be between 0 and 2 for Excel before 2007, otherwise 0+.
(idx - 规则的位置。对于 2007 年之前的 Excel,应介于 0 和 2 之间,否则为 0+。)
cfRule
- - Conditional Formatting rule
(cfRule - - 条件格式规则)
public void addRule(HSSFConditionalFormattingRule cfRule)
cfRule
- - Conditional Formatting rule
(cfRule - - 条件格式规则)
public void addRule(ConditionalFormattingRule cfRule)
ConditionalFormatting
addRule
in interface
ConditionalFormatting
(接口ConditionalFormatting中的addRule)
cfRule
- - Conditional Formatting rule
(cfRule - - 条件格式规则)
public HSSFConditionalFormattingRule getRule(int idx)
getRule
in interface
ConditionalFormatting
(接口 ConditionalFormatting 中的 getRule)
public int getNumberOfRules()
getNumberOfRules
in interface
ConditionalFormatting
(接口 ConditionalFormatting 中的 getNumberOfRules)
public java.lang.String toString()
toString
in class
java.lang.Object
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.