poi excel 插入批注
excel批注的使用注意点：
一个sheet中仅可以创建一个Patriarch，Patriarch是用来创建Comment的。如果创建了多个Patriarch，则不能正常添加注释。

import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFComment;import org.apache.poi.hssf.usermodel.HSSFRichTextString;import org.apache.poi.hssf.usermodel.HSSFPatriarch;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFClientAnchor;import java.io.IOException;import java.io.FileOutputStream;public class PoiWriter {  public static void main(String[] args) throws IOException {  //创建工作簿对象  HSSFWorkbook wb=new HSSFWorkbook();  //创建工作表对象  HSSFSheet sheet=wb.createSheet("我的工作表");  //创建绘图对象  HSSFPatriarch p=sheet.createDrawingPatriarch();  //创建单元格对象,批注插入到4行,1列,B5单元格  HSSFCell cell=sheet.createRow(4).createCell(1);  //插入单元格内容  cell.setCellValue(new HSSFRichTextString("批注"));  //获取批注对象  //(int dx1, int dy1, int dx2, int dy2, short col1, int row1, short col2, int row2)  //前四个参数是坐标点,后四个参数是编辑和显示批注时的大小.  HSSFComment comment=p.createComment(new HSSFClientAnchor(0,0,0,0,(short)3,3,(short)5,6));  //输入批注信息  comment.setString(new HSSFRichTextString("插件批注成功!插件批注成功!"));  //添加作者,选中B5单元格,看状态栏  comment.setAuthor("toad");  //将批注添加到单元格对象中  cell.setCellComment(comment);  //创建输出流  FileOutputStream out=new FileOutputStream("writerPostil.xls");  wb.write(out);  //关闭流对象  out.close(); }}