导出Excel，将图片在Excel里导出

package com.rongyungov.socins.api;

import com.spire.xls.*;

public class test {
    public static void main(String[] args) {

        String filePath = "c://socins//upload//excel/";
        //创建Workbook对象
        Workbook wb = new Workbook();
        //导入模板
        wb.loadFromFile(filePath+"zzhy.xlsx");
        //声明Workbook变量
        Workbook newWb = new Workbook();
        newWb.setVersion(wb.getVersion());
        Worksheet newSheet = newWb.getWorksheets().get("sheet1");
        //复制
        Worksheet orderSheet = wb.getWorksheets().get("sheet1");
        newSheet.copyFrom(orderSheet);


        //查找文档中的字符串“姓 名”
        CellRange[] xmRanges = newSheet.findAllString("xm", false, false);
        for (CellRange range : xmRanges) {
            //写入
            range.setText("姓名");
        }

        CellRange[] zpRanges = newSheet.findAllString("tp", false, false);
        for (CellRange range : zpRanges) {
            range.setText("");
            //获取单元格所在的行列
            int row = range.getRow();
            int colum = range.getColumn();
            //添加图片到获取的单元格内
            ExcelPicture picture = newSheet.getPictures().add(row, colum, "C:\\socins\\upload\\imgs\\1-20200804-2113.jpg", ImageFormatType.Jpeg);
            //配置图片的宽和高
            picture.setHeight(130);
            picture.setWidth(120);
        }
        //保存文档
        newWb.saveToFile(filePath+"/"+"test"+".xlsx", ExcelVersion.Version2013);

    }
}