需求说明
项目中需要将企业已有员工信息通过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