JAVA导入带有图片的excel

需求说明

项目中需要将企业已有员工信息通过excel的形式导入到系统中，方便企业快速便捷使用系统

导入依赖jar

    <!--导入Excel-->
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.9</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.9</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-schemas -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml-schemas</artifactId>
        <version>3.9</version>
    </dependency>

Excel上传

首先我们需要将excel上传到服务器，以用来程序读取excel

读取excel

根据我们上传的excel的服务器路径，进行读取excel

package com.firstdream.customer.util.system;

import com.alibaba.fastjson.JSONObject;
import com.customer.sys.entity.ExcelColumn;
import org.apache.poi.POIXMLDocumentPart;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTMarker;
import java.io.*;
import java.net.URL;
import java.net.URLConnection;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.*;

public class ExcelInUtil {

public static List<Map<String, Object>>  readExcel(String filePath,List<ExcelColumn> columnList) throws IOException {
    filePath = filePath.replace("\\", "/");
    System.out.println(filePath);
    URL url = n