如何用 Java 设置 Excel 背景色？

jdk1.8

引入POI依赖:

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>5.0.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>5.0.0</version>
</dependency>

public class Main {
    public static void main(String[] args) {
        try (XSSFWorkbook workbook = new XSSFWorkbook();
             OutputStream out = Files.newOutputStream(Paths.get("workbook.xlsx"))) {
            Sheet sheet = workbook.createSheet();
            Row row = sheet.createRow((short) 0);
            Cell cell = row.createCell((short) 0);
            cell.setCellValue("TEST---");
            // 创建一个单元格样式
            XSSFCellStyle style = workbook.createCellStyle();
            cell.setCellStyle(style);
            // 填充色
            style.setFillForegroundColor(HSSFColor.HSSFColorPredefined.BLUE.getIndex());
            style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
            // 字体颜色
            Font font = workbook.createFont();
            font.setColor(IndexedColors.WHITE.getIndex());
            style.setFont(font);
            workbook.write(out);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }

    }
}

实现效果:

参考:

https://blog.csdn.net/lipinganq/article/details/78132021