记录：excel字体颜色，写入图片

 excel字体颜色

InputStream testExcel = TestUtils.class.getClassLoader().getResourceAsStream("test.xlsx");
XSSFWorkbook wb = new XSSFWorkbook(Objects.requireNonNull(testExcel));
XSSFSheet sheet = wb.getSheetAt(0);

XSSFFont red = wb.createFont();
red.setColor(HSSFColor.HSSFColorPredefined.RED.getIndex());

XSSFFont song = wb.createFont();
song.setFontName("仿宋");
song.setFontHeightInPoints((short) 11);

XSSFCell cell = sheet.getRow(0).getCell(0);
String test = "标红仿宋";
XSSFRichTextString xssfRichTextString = new XSSFRichTextString(test);
xssfRichTextString.applyFont(0, 1, red);
xssfRichTextString.applyFont(2, test.length() - 1, song);
cell.setCellValue(xssfRichTextString);

excel写入图片

InputStream testExcel = TestUtils.class.getClassLoader().getResourceAsStream("test.xlsx");
XSSFWorkbook wb = new XSSFWorkbook(Objects.requireNonNull(testExcel));
XSSFSheet sheet = wb.getSheetAt(0);

XSSFDrawing patriarch = sheet.createDrawingPatriarch();
File file = new File("pathname");
whiteImg(patriarch, wb, file);

/**
 * 写入图片到Excel指定的位置
 * @param patriarch 画图的顶级管理器，一个sheet只能获取一次，多次插入图片请使用同一个patriarch对象
 * @param wb        HSSFWorkbook对象
 * @param file      图片文件
 * @throws IOException
 */
public static void whiteImg(XSSFDrawing patriarch, XSSFWorkbook wb, File file) throws IOException {
    ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
    BufferedImage bufferImg = ImageIO.read(file);
    ImageIO.write(bufferImg, "png", byteArrayOut);

    // 起点坐标
    int x1 = 0;
    int y1 = 0;
    // 终点坐标
    int x2 = 1;
    int y2 = 1;
    // anchor主要用于设置图片的属性
    XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 0, 0, (short) x1, y1, (short) x2, y2);
    // 插入图片
    int index = wb.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PICT);
    patriarch.createPicture(anchor, index);
}