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

本文將向您展示如何通過在Java應用程序中使用Spire.XLS在Excel工作表中將搜索的文本替換為圖像。

免費下載Spire.XLS最新版

Excel范例：

import com.spire.xls.*;
import java.io.IOException;

public class replaceTextwithImage {
    public static void main(String[] args) throws IOException {

        //Load the sample Excel document
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");
        //Get the first worksheet
        Worksheet worksheet = workbook.getWorksheets().get(0);

        //Find the text string {{Image}}
        CellRange[] ranges = worksheet.findAllString("{{Image}}", false, false);
        for (CellRange range : ranges) {
            //set the text as null
            range.setText("");

            //get the row and column of the searched range
            int row = range.getRow();
            int column = range.getColumn();
            //Add the image to the searched range
            worksheet.getPictures().add(row, column, "logo.jpg", ImageFormatType.Jpeg);

            //Save the document to file
            workbook.saveToFile("replaceTextwithImage.xlsx", ExcelVersion.Version2013);
            }
        }
    }

效果圖：

---

慧都是E-iceblue官方友好合作伙伴，如果您對spire.xls，可以了解具體授權價格和使用機制