java poi注解使用_java – 在apache poi中使用HSSFClientAnchor创建单元格注释

有点晚了,但这可能会起作用(它适用于我,而快速启动的Apache POI示例对我来说也不起作用)：

public void setComment(String text, Cell cell) {

final Map drawingPatriarches = new HashMap();

CreationHelper createHelper = cell.getSheet().getWorkbook().getCreationHelper();

HSSFSheet sheet = (HSSFSheet) cell.getSheet();

HSSFPatriarch drawingPatriarch = drawingPatriarches.get(sheet);

if (drawingPatriarch == null) {

drawingPatriarch = sheet.createDrawingPatriarch();

drawingPatriarches.put(sheet, drawingPatriarch);

}

Comment comment = drawingPatriarch.createComment(new HSSFClientAnchor(0, 0, 0, 0, (short) 4, 2, (short) 6, 5));

comment.setString(createHelper.createRichTextString(text));

cell.setCellComment(comment);

}

埃里克·格拉特