internship：利用easypoi将excel表数据导入导出

最新推荐文章于 2022-10-13 12:27:27 发布

ahyo

最新推荐文章于 2022-10-13 12:27:27 发布

阅读量132

点赞数

分类专栏：实习所见所实践文章标签： java 开发语言

本文链接：https://blog.csdn.net/yooppa/article/details/126061339

版权

实习所见所实践专栏收录该内容

35 篇文章 0 订阅

订阅专栏

@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@TableName("employer")
public class BizEmployer extends Model<BizEmployer> {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;
    /**
     * 姓名
     */
    @Excel(name = "姓名",width = 25)
    private String name;

    /**
     * 性别
     */
    private Integer sex;

    @TableField(exist = false)
    @ApiModelProperty(value="性别")
    private String sexStr;

    @TableField(exist = false)
    @ApiModelProperty(value="年龄")
    private String age;

    @Excel(name = "身份证号",width = 25)
    @TableField("id_card")
    @ApiModelProperty(value="身份证号")
    private String idCard;



     .......

    /**
     * 上传人员excel
     *
     * @param file
     * @return
     */
    @RequestMapping(value = "/uploadExcel", method = RequestMethod.POST)
    public ResponseData uploadExcel(HttpServletRequest request, MultipartFile file) {
        ImportParams importParams = new ImportParams();
        importParams.setTitleRows(1);
        List<BizEmployer> result;
        try {
            result = ExcelImportUtil.importExcel(file.getInputStream(), BizEmployer.class, importParams);
        } catch (Exception e) {
            e.printStackTrace();
            throw new BusinessException(500, "表格导入错误!");
        }
        //保存员工信息
        if (ToolUtil.isEmpty(result)) {
            throw new BusinessException(BizExceptionEnum.EXCEL_EMPTY);
        }
        List<BizEmployer> errorList = employerService.importExcel(result);
        request.getSession().setAttribute("employerList", errorList);
        return new ResponseData<>(errorList.size() == 0);
    }