POI Multiple cell comments in one cell are not allowed问题解决

问题描述：

Multiple cell comments in one cell are not allowed:D5

问题分析：

1、在给.xlsx文件加批注时出现了报错，POI对.xlsx文件不是很兼容。

public static void addHSSFComment(Cell cell,String value){
    Comment comment = cell.getSheet().createDrawingPatriarch().createCellComment(new HSSFClientAnchor(0, 0, 0,0, (short) 3, 3, (short) 5, 6));
    // 输入批注信息
    comment.setString(new HSSFRichTextString(value));
    // 将批注添加到单元格对象中
    cell.setCellComment(comment);
}

解决办法：

（1）将要操作的文件换成xls格式。

（2）不更换文件格式，将之前给单元格添加批注的代码换成下面的代码。

public static void addXSSFComment(Cell cell,String value){
    Sheet sheet = cell.getSheet();
    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);
}