java导入excel

pom.xml添加poi依赖
<!--解析excel-->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>RELEASE</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>RELEASE</version>
</dependency>

//处理excel数据
public List getexcel( @RequestParam("file") MultipartFile file){
    List excels = new ArrayList<>();

    String fileName = file.getOriginalFilename();
    Workbook workbook = null;
    InputStream in = null;
    try {
        //获取输入流
        in = file.getInputStream();
        //判断excel版本
        if (fileName.matches("^.+\\.(?i)(xls)$")){
            workbook = new HSSFWorkbook(in);
        }else {
            workbook = new XSSFWorkbook(in);
        }
        //获取第一张工作表
        Sheet sheet = workbook.getSheetAt(0);
        
        //获取总行数
        int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
        //第一列是表头
        Row row1 = sheet.getRow(0);
        //总列数
        int cellsize = row1.getPhysicalNumberOfCells();
        //从第二行开始获取 
        Row row = null;
        HashMap map = null;
        for (int i = 1; i < physicalNumberOfRows; i++) {
            //行数据
            row = sheet.getRow(i);
            map = new HashMap();
            //循环获取每一列
            for(int j = 0; j < cellsize; j++){
                Cell cell0 = row.getCell(j);
                if (cell0 != null)
                    map.put(row1.getCell(j).toString(),cell0.toString());
            }
            excels.add(map);
        }

    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        //关闭资源
        try {
            workbook.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        try {
            in.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    return excels;
}