问题描述:
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());
ancho