【PUSDN】java中easyexcel导入导出带有图片的Excel（main方法方式）

package com.pgz.test.eetpic;
 
import cn.hutool.core.io.FileUtil;
import cn.hutool.core.lang.UUID;
import cn.hutool.core.util.StrUtil;
import cn.hutool.poi.excel.ExcelPicUtil;
import cn.hutool.poi.excel.ExcelUtil;
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.ExcelReader;
import com.alibaba.excel.event.AnalysisEventListener;
import com.alibaba.excel.read.metadata.ReadSheet;
import com.alibaba.fastjson.JSON;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.ss.usermodel.PictureData;
 
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
 
/**
 * easy excel图片读取示例，main方法方式，web方式详见另外一个
 */
@Slf4j
public class EETest {
    public static void main(String[] args) throws Exception {
        String fileName = "/Users/janeyork/Downloads/487_1.xlsx";
        InputStream fis = new FileInputStream(fileName);
 
        AnalysisEventListener listener = new UserInfoDataListener();
 
        ExcelReader excelReader = EasyExcel.read(fis, ExcelData.class, listener).build();
        ReadSheet readSheet = EasyExcel.readSheet(0).build();
        ReadSheet readSheet2 = EasyExcel.readSheet(1).build();
        excelReader.read(readSheet);
        // 这里千万别忘记关闭，读的时候会创建临时文件，到时磁盘会崩的
        excelReader.finish();
 
        List<ExcelData> list = new ArrayList<>();
        InputStream fis2 = new FileInputStream(fileName);
        cn.hutool.poi.excel.ExcelReader reader = ExcelUtil.getReader(fis2);
        //key是图片位置，row_cell的格式；value是图片数据
        Map<String, PictureData> picMap = ExcelPicUtil.getPicMap(reader.getWorkbook(), 0);
 
        log.info("图片:" + picMap.size());
        //这里只关心行数，把数据装到Bean里面去，也可用map在循环中取获取
        picMap.forEach((k, v) -> {
            log.info("----------------------");
            String[] split = k.split(StrUtil.UNDERLINE);
            Integer index = Integer.valueOf(split[0]);
 
            log.info("图片:" + k);
            log.info("图片:" + v);
            String mimeType = v.getMimeType();
            String[] mimeTypes = mimeType.split(StrUtil.SLASH);
            log.info("mimeType:" + mimeType);
            String fileName2 = "/Users/janeyork/Downloads/eetpictmp/"+UUID.randomUUID() + "." + mimeTypes[1];
            // 模拟上传
            FileUtil.writeBytes(v.getData(), fileName2);
            // 然后将上传成功图片路径，赋值给实体类，然后调用service插入数据库即可
        });
 
    }
 
}