excel文档上传批量读取入库

结合上节下载模板实现数据批量导入功能(上节内容 https://blog.youkuaiyun.com/fcfs_sstf/article/details/136297469)
结合swagger注解 @ApiModelProperty 识别excel表头

构建实体类

import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

@AllArgsConstructor
@NoArgsConstructor
@Data
@Builder
public class UserImport {
   
    @ApiModelProperty(value="用户名")
    private String username;

    @ApiModelProperty(value="姓名")
    private String realName;

    @ApiModelProperty(value="电话")
    private String phone;

    @ApiModelProperty(value="状态(1:启用 0：禁用)")
    private String status;
}

业务代码

 public Result importUserList(MultipartFile multipartFile) {
   
        List<UserImport> userImports = ExcelUtils.readExcel(multipartFile, UserImport.class);
        List<SysUser> list = new ArrayList<>();
        if (CollUtil.isNotEmpty(userImports)) {
   
            //业务代码....
        }
        return ResultUtil.success();
    }

主要实现方法

注意编码格式按实际情况配置

public static <<