jxl 操作excle 修改 添加 追加批注 java

import java.io.File;import java.util.regex.Matcher;import java.util.regex.Pattern;import jxl.Sheet;import jxl.Workbook;import jxl.format.CellFormat;import jxl.write.Label;import jxl.write.WritableCell;import jxl.write.WritableCellFeatures;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;public class ExcelTools {/** *  * 设置excel修改批注信息 *  * @param File file 文件 * @param Workbook book  * @param int col 列坐标 * @param int row 行坐标 * @param String text 批注信息 * @return boolean true|false */public synchronized static boolean updateCmment(File file, Workbook book, int col, int row, String text) {WritableWorkbook wbe = null;WritableSheet sheet = null;WritableCell cell = null;int height;try {wbe = Workbook.createWorkbook(file, book);//创建workbook的副本  sheet = wbe.getSheet(0);  //获取第一个sheet          cell =sheet.getWritableCell(col, row);       //获取第一个单元格          WritableCellFeatures cellFeatures = new WritableCellFeatures(); //创建空的featuresif(null != cell.getCellFeatures()){cell.getCellFeatures().removeComment();}else{cell.setCellFeatures(cellFeatures);}height = getCommentRows(text, "\r\n");cellFeatures.setComment(text, 3, height+2);cell.setCellFeatures(cellFeatures);return true;} catch (Exception e) {e.printStackTrace();return false;}finally{try {wbe.write();//将修改保存到workbookwbe.close();//关闭workbook，释放内存} catch (Exception e) {e.printStackTrace();}    }}/** *  * 设置excel追加批注信息,保留原来批注 *  * @param File file 文件 * @param Workbook book  * @param int col 列坐标 * @param int row 行坐标 * @param String text 批注信息 * @return boolean true|false */public synchronized static boolean addCmment(File file, Workbook book, int col, int row, String text) {WritableWorkbook wbe = null;WritableSheet sheet = null;WritableCell cell = null;String oldmark = null;int height;try {wbe = Workbook.createWorkbook(file, book);//创建workbook的副本  sheet = wbe.getSheet(0);  //获取第一个sheet          cell =sheet.getWritableCell(col, row);       //获取第一个单元格          WritableCellFeatures cellFeatures = new WritableCellFeatures(); //创建空的featuresoldmark = cell.getCellFeatures() == null ? null : cell.getCellFeatures().getComment();//原批注if(null != oldmark){cell.getCellFeatures().removeComment();text = oldmark + "\r\n---------------\r\n" + text;}else{cell.setCellFeatures(cellFeatures);}height = getCommentRows(text, "\r\n");cellFeatures.setComment(text, 3, height+3);cell.setCellFeatures(cellFeatures);return true;} catch (Exception e) {e.printStackTrace();return false;}finally{try {wbe.write();//将修改保存到workbookwbe.close();//关闭workbook，释放内存} catch (Exception e) {e.printStackTrace();}    }}/** *  * 设置删除批注信息 *  * @param File file 文件 * @param Workbook book  * @param int col 列坐标 * @param int row 行坐标 * @return boolean true|false */public synchronized static boolean removeCmment(File file, Workbook book, int col, int row) {WritableWorkbook wbe = null;WritableSheet sheet = null;WritableCell cell = null;try {wbe = Workbook.createWorkbook(file, book);//创建workbook的副本  sheet = wbe.getSheet(0);  //获取第一个sheet          cell =sheet.getWritableCell(col, row);       //获取第一个单元格          WritableCellFeatures cellFeatures = new WritableCellFeatures(); //创建空的featuresif(null != cell.getCellFeatures()){cell.getCellFeatures().removeComment();}cell.setCellFeatures(cellFeatures);return true;} catch (Exception e) {e.printStackTrace();return false;}finally{try {wbe.write();//将修改保存到workbookwbe.close();//关闭workbook，释放内存} catch (Exception e) {e.printStackTrace();}    }}public static int getCommentRows(String str, String findstr){String regEx = findstr; //要匹配的子串，可以用正则表达式 Pattern p = Pattern.compile(regEx); Matcher m = p.matcher(str); int i = 0;while(m.find()) {i++;}return i;}/** * 测试 */public static void main(String[] args) throws Exception {//添加批注startFile file =  new File("D://001311600.xls");//File file =  new File("D://3333.xls");Workbook book = Workbook.getWorkbook(file);Sheet sheet = book.getSheet(0);System.out.println(sheet.getRow(0)[0].getContents());//打印坐标 0,0 文字信息ExcelTools.addCmment(file, book, 0, 0, "测试787123456789012");//ExcelTools.updateCmment(file, book, 0, 0, "测试787123456789012\r\n");//ExcelTools.removeCmment(file, book, 0, 0);        book.close();        }}