<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>15.5.1</version>
    </dependency>
</dependencies>

import com.spire.xls.*;
import java.awt.*;
 
public class HighlightThreshold {
   public static void main(String[] args) {
 
       // 創(chuàng)建 Workbook 實(shí)例并加載 Excel 文件
       Workbook workbook = new Workbook();
       workbook.loadFromFile("/input/銷售匯總.xlsx");
 
       // 獲取第一個(gè)工作表
       Worksheet sheet = workbook.getWorksheets().get(0);
 
       // 對(duì) E2:E15 區(qū)域添加條件格式：銷售額小于 5000 時(shí)背景變紅
       ConditionalFormatWrapper format = sheet.getCellRange("E2:E15")
               .getConditionalFormats().addCondition();
       format.setFormatType(ConditionalFormatType.CellValue);
       format.setOperator(ComparisonOperatorType.Less);
       format.setFirstFormula("5000"); 
       format.setBackColor(Color.red);
 
       // 保存文檔
       workbook.saveToFile("/output/高亮數(shù)值.xlsx", ExcelVersion.Version2016);
   }
}

import com.spire.xls.*;
import com.spire.xls.core.IConditionalFormat;
import com.spire.xls.core.spreadsheet.collections.XlsConditionalFormats;
 
import java.awt.*;
 
public class Highlightwithtrafficlight {
   public static void main(String[] args) {
       // 新建實(shí)例
       Workbook workbook = new Workbook();
       workbook.loadFromFile("/input/銷售匯總.xlsx");
 
       // 獲取第一個(gè)工作表
       Worksheet sheet = workbook.getWorksheets().get(0);
 
       // 選中 B2:B15 區(qū)域
       CellRange targetRange = sheet.getCellRange("B2:B15");
 
       // 創(chuàng)建條件格式集合并應(yīng)用到選中區(qū)域
       XlsConditionalFormats conditional = sheet.getConditionalFormats().add();
       conditional.addRange(targetRange);
 
       // 添加圖標(biāo)集條件格式：三色交通燈
       IConditionalFormat format = conditional.addCondition();
       format.setFormatType(ConditionalFormatType.IconSet);
       format.getIconSet().setIconSetType(IconSetType.ThreeTrafficLights1);
 
       // 保存結(jié)果文件
       workbook.saveToFile("/output/庫(kù)存預(yù)警-交通燈1.xlsx", ExcelVersion.Version2013);
   }
}

import com.spire.xls.*;
import java.awt.*;
 
public class HighlightWithFormula {
   public static void main(String[] args) {
 
       // 創(chuàng)建實(shí)例并導(dǎo)入 Excel 文件
       Workbook workbook = new Workbook();
       workbook.loadFromFile("/input/銷售匯總.xlsx");
 
       // 獲取第一個(gè)工作表
       Worksheet sheet = workbook.getWorksheets().get(0);
 
       // 設(shè)置條件格式區(qū)域
       CellRange range = sheet.getCellRange("A2:E15");
 
       // 添加公式條件格式：當(dāng)庫(kù)存 < 50 且銷售額 < 5000 時(shí)，格式生效
       ConditionalFormatWrapper format = range.getConditionalFormats().addCondition();
       format.setFormatType(ConditionalFormatType.Formula);
       format.setFirstFormula("=AND($B2<50,$E2<5000)");
       format.setBackColor(Color.ORANGE);
 
       // 保存結(jié)果
       workbook.saveToFile("output/高亮數(shù)值-公式.xlsx", ExcelVersion.Version2016);
   }
}