国产Excel开发组件Spire.XLS教程：在Java中以编程方式在Excel中将图像注释添加到Excel

*这么优秀的国产工具怎能错过呢！在线下单专享“一口价”，立即购买！想要获取更多福利的朋友可以咨询在线客服哦~

代码如下：

import com.spire.xls.*;import javax.imageio.ImageIO;import java.awt.image.BufferedImage;import java.io.*;public class Test {    public static void main(String[] args)throws IOException {        //Load the sample Excel file        Workbook workbook = new Workbook();        workbook.loadFromFile("Sample.xlsx");        //Get the first worksheet        Worksheet sheet = workbook.getWorksheets().get(0);        //set the font        ExcelFont font = workbook.createFont();        font.setFontName("Arial");        font.setSize(11);        font.setKnownColor(ExcelColors.Orange);        CellRange range = sheet.getCellRange("D1");        //Add the commet        ExcelComment comment = range.addComment();        //Load the image        BufferedImage bufferedImage = ImageIO.read(new File("Logo.jpg"));        //Use the image to fill the comment        comment.getFill().customPicture(bufferedImage, "Logo.jpg");        //Set the height and width for the comment        comment.setHeight(bufferedImage.getHeight());        comment.setWidth(bufferedImage.getWidth());        //Show the comment        comment.setVisible(true);        //Save the document to file        workbook.saveToFile("output/setimageComment.xlsx", ExcelVersion.Version2013);    }}

输出结果：

---

是E-iceblue官方友好合作伙伴，如果您对spire.xls，可以联系在线客服了解具体授权价格和使用机制

标签：