POI 给单元格添加批注

Dear 丶 2022-11-09 12:58 644阅读 0赞

/**
         * 给Cell添加批注
         *
         * @param cell 单元格
         * @param value 批注内容
         * @param extension 扩展名
         */
        public static void addComment(Cell cell, String value, String extension) {
            Sheet sheet = cell.getSheet();
            cell.removeCellComment();
            if ("xls".equals(extension)) {
                ClientAnchor anchor = new HSSFClientAnchor();
                // 关键修改
                anchor.setDx1(0);
                anchor.setDx2(0);
                anchor.setDy1(0);
                anchor.setDy2(0);
                anchor.setCol1(cell.getColumnIndex());
                anchor.setRow1(cell.getRowIndex());
                anchor.setCol2(cell.getColumnIndex() + 5);
                anchor.setRow2(cell.getRowIndex() + 6);
                // 结束
                Drawing drawing = sheet.createDrawingPatriarch();
                Comment comment = drawing.createCellComment(anchor);
                // 输入批注信息
                comment.setString(new HSSFRichTextString(value));
                // 将批注添加到单元格对象中
                cell.setCellComment(comment);
            } else if ("xlsx".equals(extension)) {
                ClientAnchor anchor = new XSSFClientAnchor();
                // 关键修改
                anchor.setDx1(0);
                anchor.setDx2(0);
                anchor.setDy1(0);
                anchor.setDy2(0);
                anchor.setCol1(cell.getColumnIndex());
                anchor.setRow1(cell.getRowIndex());
                anchor.setCol2(cell.getColumnIndex() + 5);
                anchor.setRow2(cell.getRowIndex() + 6);
                // 结束
                Drawing drawing = sheet.createDrawingPatriarch();
                Comment comment = drawing.createCellComment(anchor);
                // 输入批注信息
                comment.setString(new XSSFRichTextString(value));
                // 将批注添加到单元格对象中
                cell.setCellComment(comment);
            }
        }