如何用 Java 设置 Excel 背景色？-灵析社区

jdk1.8 引入POI依赖: org.apache.poi poi 5.0.0 org.apache.poi poi-ooxml 5.0.0 * * * 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](https://link.segmentfault.com/?enc=EP1OpvGcnO6pMeOBB8sxbg%3D%3D.OhWNkHZpvxbD2%2BZh8e%2FiuEpmgOVE7OYajbQcPe1ZIMQZbaG4j9Qxh4HjDRIVqOmnq0JIjLzs%2FMLzVL0o4oqaLg%3D%3D)