public interface ConditionalFormatting
ConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);
Sheet.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. ConditionalFormattingRule rule = sheet.createConditionalFormattingRule( ComparisonOperator.GE, "100.0", // 1st formula null // 2nd formula is not used for comparison operator GE ); // Create pattern with red background PatternFormatting patternFmt = rule.cretePatternFormatting(); patternFormatting.setFillBackgroundColor(IndexedColor.RED.getIndex()); // 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);(ConditionalFormatting 类封装了 Conditional Formatting 的所有设置。该类可用于复制 ConditionalFormatting 设置。例如:ConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);或修改现有的条件格式设置(格式化区域和/或规则)。使用 Sheet.getSheetConditionalFormatting() 来访问此类的实例。要创建新的条件格式集,请使用以下方法: // 定义条件格式规则,当单元格的值大于或等于 100.0 时触发格式化 // 并应用下面定义的 patternFormatting。 ConditionalFormattingRule rule = sheet.createConditionalFormattingRule(ComparisonOperator.GE, "100.0", // 第一个公式 null // 第二个公式不用于比较运算符 GE ); // 创建带有红色背景的图案 PatternFormatting patternFmt = rule.cretePatternFormatting(); patternFormatting.setFillBackgroundColor(IndexedColor.RED.getIndex()); // 定义一个包含第一列的区域 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.
(添加条件格式规则。)
|
CellRangeAddress[] |
getFormattingRanges() |
int |
getNumberOfRules() |
ConditionalFormattingRule |
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 处的现有条件格式规则。)
|
CellRangeAddress[] getFormattingRanges()
null
(CellRangeAddresss 数组。从不为空)
void setFormattingRanges(CellRangeAddress[] ranges)
ranges
- non-null array of
CellRangeAddresss
(范围 - CellRangeAddresss 的非空数组)
void setRule(int idx, ConditionalFormattingRule cfRule)
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 - - 条件格式规则)
void addRule(ConditionalFormattingRule cfRule)
cfRule
- - Conditional Formatting rule
(cfRule - - 条件格式规则)
ConditionalFormattingRule getRule(int idx)
int getNumberOfRules()
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.