使用pio添加excel表格批注并保存

public static void main(String[] args) throws Exception {
    File file = new File("C:\\Users\\px\\Desktop\\xxxx.xls");
    addPostil(file,"Sheet2",5,0,"俺是批注");
}

/**
* 添加批注
* @param file 文件
* @param sheetName sheet名
* @param rownum 行号
* @param column 列号
* @param postilStr 批注名称
* @throws Exception
*/
public static void addPostil(File file, String sheetName, int rownum,int column,String postilStr) throws Exception {
    FileInputStream exlFile = new FileInputStream(file);

    // POI给出的解决兼容Excel 2003和2007以上版本的方法
    Workbook workbook = WorkbookFactory.create(exlFile);

    if (workbook instanceof HSSFWorkbook) {
        postilHSSF(((HSSFWorkbook) workbook).getSheet(sheetName),rownum,column,postilStr);
    } else if (workbook instanceof XSSFWorkbook) {
        postilXSSF(((XSSFWorkbook) workbook).getSheet(sheetName),rownum,column,postilStr);
    }
    exlFile.close();// 关闭文件输入流
    FileOutputStream fos = new FileOutputStream(file);
    workbook.write(fos);
    fos.close();// 关闭文件输出流
}

public static void postilHSSF(HSSFSheet sheet,int rownum,int column,String postilStr){
    //创建绘图对象
    HSSFPatriarch p=sheet.createDrawingPatriarch();
    //创建单元格对象
    HSSFCell cell=sheet.createRow(rownum).createCell(column);
    //获取批注对象
    //(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(postilStr));
    //将批注添加到单元格对象中
    cell.setCellComment(comment);
}

public static void postilXSSF(XSSFSheet sheet,int rownum,int column,String postilStr){
    //创建绘图对象
    XSSFDrawing p = sheet.createDrawingPatriarch();
    //创建单元格对象
    XSSFCell cell = sheet.createRow(rownum).createCell(column);
    //获取批注对象
    //(int dx1, int dy1, int dx2, int dy2, short col1, int row1, short col2, int row2)
    //前四个参数是坐标点,后四个参数是编辑和显示批注时的大小.
    XSSFComment comment = p.createCellComment(new XSSFClientAnchor(0,0,0,0,(short)3,3,(short)5,6));
    //输入批注信息
    comment.setString(new XSSFRichTextString(postilStr));
    //将批注添加到单元格对象中
    cell.setCellComment(comment);
}