Java添加、读取和删除Excel批注的操作代码

 

  com.e-iceblue

  e-iceblue

  http://repo.e-iceblue.com/nexus/content/groups/public/

 





 

  e-iceblue

  spire.xls.free

  2.2.0

 

importcom.spire.xls.\*;

publicclassAddComments{

 publicstaticvoidmain(String\[\]args){

  //新建Excel文档

  Workbookworkbook\=newWorkbook();

  //获取第一张工作表

  Worksheetsheet\=workbook.getWorksheets().get(0);

  //设置工作表名称

  sheet.setName("批注");

  //添加文本到单元格\[1,1\]

  CellRangerange\=sheet.getCellRange(1,1);

  range.setText("添加批注:");

  //添加文本到单元格 \[5,1\]

  CellRangerange1\=sheet.getCellRange(5,1);

  range1.setText("批注");

  //添加批注到单元格 \[5,1\]

  range1.getComment().setText("这是一个批注\\n它可以是多行的。");

  //展示批注

  range1.getComment().setVisible(true);

  //设置批注高度

  range1.getComment().setHeight(100);

  //创建字体并设置字体颜色

  ExcelFontfontBlue\=workbook.createFont();

  fontBlue.setKnownColor(ExcelColors.LightBlue);

  ExcelFontfontGreen\=workbook.createFont();

  fontGreen.setKnownColor(ExcelColors.LightGreen);

  //设置批注文本中各个字符的字体

  range1.getComment().getRichText().setFont(0,1,fontGreen);

  range1.getComment().getRichText().setFont(2,3,fontBlue);

  range1.getComment().getRichText().setFont(4,5,fontGreen);

  //保存结果文档

  workbook.saveToFile("添加批注.xlsx",ExcelVersion.Version2013);

 }

}

importcom.spire.xls.\*;

publicclassReadComments{

 publicstaticvoidmain(String\[\]args){

  //加载Excel文档

  Workbookworkbook\=newWorkbook();

  workbook.loadFromFile("添加批注.xlsx");

  //获取第一张工作表

  Worksheetsheet\=workbook.getWorksheets().get(0);

  //打印工作表中所有的批注

  for(inti\=0;i

importcom.spire.xls.\*;

publicclassDeleteComments{

 publicstaticvoidmain(String\[\]args){

  //加载Excel文档

  Workbookworkbook\=newWorkbook();

  workbook.loadFromFile("添加批注.xlsx");

  //获取第一张工作表

  Worksheetsheet\=workbook.getWorksheets().get(0);

  //删除工作表中所有批注

  for(inti\=0;i