HSSFPatriarch patr = sheet.createDrawingPatriarch();
HSSFComment comment ;
comment = patr.createCellComment(new HSSFClientAnchor(0, 0,
0, 0, (short) 0, 0, (short) 3, 3));
comment.setString(new HSSFRichTextString(commenttext));
sheet.getRow(row).getCell(cell).setCellComment(comment);
HSSFPatriarch: 画图的顶级管理器;
HSSFRichTextString : 将String型字符转为Unicode型String。Rich text unicode string. These strings can have fonts applied to arbitary parts of the string.
HSSFClientAnchor : 添加多个图片时:多个pic应该share同一个DrawingPatriarch在同一个sheet里面。public HSSFClientAnchor(int dx1,
int dy1,
int dx2,
int dy2,
short col1,
int row1,
short col2,
int row2)
- Creates a new client anchor and sets the top-left and bottom-right coordinates of the anchor.
- Parameters:
dx1
- the x coordinate within the first cell.
dy1
- the y coordinate within the first cell.
dx2
- the x coordinate within the second cell.
dy2
- the y coordinate within the second cell.
col1
- the column (0 based) of the first cell.
row1
- the row (0 based) of the first cell.
col2
- the column (0 based) of the second cell.
row2
- the row (0 based) of the second cell.
HSSFAnchor HSSFClientAnchor的父类。An anchor is what specifics the position of a shape within a client object or within another containing shape.
阅读(2519) | 评论(0) | 转发(0) |