java 复制excel_Java 复制excel批注

import com.spire.xls.*;

import java.awt.*;

import java.awt.image.BufferedImage;

public class CopyComment {

public static void main(String[] args) {

//加载Excel文档

Workbook wb = new Workbook();

wb.loadFromFile("AddComments.xlsx");

//获取指定工作表

Worksheet sheet = wb.getWorksheets().get(0);

//获取源单元格批注内容

CellRange range = sheet.getRange().get("H2");//获取指定单元格

String commenttext = range.getComment().getText();//获取批注文本

BufferedImage image = range.getComment().getFill().getPicture();//获取批注填充图片

// Object object = range.getComment().getFill().getForeColor();//获取批注填充色

//获取新的单元格，添加批注文本和图片(颜色)填充

CellRange range1 = sheet.getRange().get("D3");

range1.getComment().setText(commenttext);

range1.getComment().getFill().customPicture(image," ");

//range1.getComment().getFill().setForeColor((Color) object);

//保存文档

wb.saveToFile("CopyComment.xlsx",ExcelVersion.Version);

wb.dispose();

}

}