easypoi读取excel

  第一步加入jar //<!-- easypoi简单导出所需要的jar包start -->
    implementation group: 'cn.afterturn', name: 'easypoi-base', version: '3.2.0'
    implementation group: 'cn.afterturn', name: 'easypoi-annotation', version: '3.2.0'
    implementation group: 'cn.afterturn', name: 'easypoi-web', version: '3.2.0'


第二步 建立对象接收数据

package com.test.utils;
import javax.validation.constraints.NotBlank;
import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

import java.io.Serializable;

@Data
public class Demo implements Serializable {
    @Excel(name = "用户名")
    @NotBlank
    private  String userName;
    @Excel(name = "地址")
    private String address;
}

第三步调用方法
  @ApiOperation(value = "读取excel----Address")
    @PostMapping("/readAssetNcFileExcelAddress")
       @ApiImplicitParams({
           @ApiImplicitParam(name = "address", value = "本地读取绝对地址", dataType = "string", paramType = "query", required = true),
   })
    public String readAssetNcFileExcelAddress(String address) {
        ImportParams importParams = new ImportParams();
        // 数据处理
        importParams.setHeadRows(1);
        importParams.setTitleRows(0);
        // 需要验证
        importParams.setNeedVerfiy(true);
        try {
            System.out.println("文件地址："+address);
            File excelFile = new File(address);
            FileInputStream fileInputStream = new FileInputStream(excelFile);
            ExcelImportResult<Demo> result =
            ExcelImportUtil.importExcelMore(fileInputStream, Demo.class, importParams);
            fileInputStream.close();
            List<Demo> demoList= result.getList();
            System.out.println( "----------总条数："+demoList.size());
            int total = demoList.size();
            Date date = new Date();
            for (int i = 0; i < total; i++) {
                System.out.println("读取的行数==" +(i+1));
                //得到对象
                Demo demo= demoList.get(i);
              //进行业务处理
             
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return "ok";
    }


  @ApiOperation(value = "读取excel----upload")
    @PostMapping("/readAssetNcFileExcelUpload")
    public String readAssetNcFileExcelUpload(@RequestParam("file") MultipartFile file) {
        ImportParams importParams = new ImportParams();
        // 数据处理
        importParams.setHeadRows(1);
        importParams.setTitleRows(0);
        // 需要验证
        importParams.setNeedVerfiy(false);
        Date date = new Date();
        try {
            ExcelImportResult<Demo> result =
            ExcelImportUtil.importExcelMore(file.getInputStream(), Demo.class, importParams);
            List<Demo> demoList= result.getList();
            System.out.println(demoList.size() + "---总记录数据-------");
            int total = demoList.size();
            for (int i = 0; i < total; i++) {
                //得到对象
                Demo demo= demoList.get(i);
               //进行业务处理
              
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return "ok";
    }