Summary: | If we have a comment but the row is not created we will not be able to get it. | ||
---|---|---|---|
Product: | POI | Reporter: | Yury Gribkov <yury.gribkov> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED INVALID | ||
Severity: | trivial | CC: | yury.gribkov |
Priority: | P2 | ||
Version: | 3.6-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP |
Description
Yury Gribkov
2010-03-25 16:09:16 UTC
Hi, You can get cell comments using such chunk of code: HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(); Drawing drawing = sheet.createDrawingPatriarch(); HSSFClientAnchor clientAnchor = new HSSFClientAnchor(0, 0, 0, 0, (short) 0, 0, (short)3, 3); Comment comment = drawing.createCellComment(clientAnchor); RichTextString str = new HSSFRichTextString("Hello, World!"); comment.setString(str); comment.setRow(3); comment.setColumn(4); FileOutputStream out = new FileOutputStream("workbook.xls"); wb.write(out); out.close(); wb = new HSSFWorkbook(new FileInputStream("workbook.xls")); sheet = wb.getSheetAt(0); comment = sheet.getCellComment(3, 4); System.out.println(comment.getString().getString()); Regards, Evgeniy |