Spire.XLS教程：在Java中以編程方式在Excel中將圖像注釋添加到Excel

Spire.XLS for Java是專業的Java Excel API，使開發人員無需使用Microsoft Office或Microsoft Excel即可創建，管理，操作，轉換和打印Excel工作表。

之前已經演示了如何在Java應用程序的Excel中添加和讀取文本注釋。本文將向您展示如何使用Spire.XLS for Java將圖像注釋插入Excel。

免費下載Spire.XLS最新版

代碼如下：

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，可以了解具體授權價格和使用機制