easypoi导入核心代码

dejiangdexiaoming

于 2024-11-05 21:40:27 发布

阅读量175

点赞数 1

CC 4.0 BY-SA版权

文章标签： java

本文链接：https://blog.youkuaiyun.com/zxcblackhhh/article/details/143529228

easypoi导入核心代码

实体类

注意：@ExcelTarget和@Excel注解

@ExcelTarget("User")
public class User  implements Serializable{

    /**
     * 用户名
     */
    @Excel(name = "用户名")
    private String userName;

    /**
     * 手机号
     */
    @Excel(name = "手机号码")
    private String userPhone;

    /**
     * 身份证号码
     */
    @Excel(name = "身份证号码")
    private String idCard;

}

业务操作

@PostMapping("/importUser")
    public void importUser(MultipartFile file, String draftId, String userId) throws Exception {
        ImportParams params = new ImportParams();
        params.setTitleRows(0);

        List<User> users = ExcelImportUtil.importExcel(file.getInputStream(), User.class, params);

        System.out.println("users:"+users);
        System.out.println("draftId:"+draftId);
        System.out.println("userId:"+userId);
    }