private void addComment(XSSFWorkbook wb, XSSFCell cell, BigDecimal prodPrice) {
XSSFSheet sheet = wb.getSheetAt(0);
XSSFDrawing draw = sheet.createDrawingPatriarch();
//前4个参数代表单元格的"偏移量",参数5,7分别代表当前单元格相对的"起始列"/"终止列",参数6,8分别代表当前单元格相对的"起始行"/"终止行"
XSSFComment comment = draw.createCellComment(new XSSFClientAnchor(0, 0, 0, 0, 4, 2, 6, 5));
XSSFRichTextString rtf = new XSSFRichTextString("原产品单价: " + prodPrice);
XSSFFont commentFormatter = wb.createFont();
commentFormatter.setFontName("宋体");
commentFormatter.setFontHeightInPoints((short) 9);
rtf.applyFont(commentFormatter);
comment.setString(rtf);
cell.setCellComment(comment);
}
poi对excel添加批注
最新推荐文章于 2021-10-28 18:04:30 发布