java - Apache POI 带有公式的颜色单元格

Question

我想使用 Java 中的 Apache POI 创建 Excel，并且必须在单元格中插入公式:A3=B3+C3。

是否可以在 A3 中插入​​另一个公式，如果其值为 > 0，则为单元格着色？

我使用 Apache POI 2.5.1

Answer 1

您将需要 conditional formatting .

摘自本文档:

 // 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);

它创建一个具有红色背景的单元格，其值 >= 100。这几乎就是您想要的:-)