基于SpringBoot+EasyExcel+vue3实现excel表格的导入和导出
package com.kang.domain;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
/**
* @ClassName User
* @Description TODO
* @Author kang
* @Date 2022/3/7 上午 8:07
* @Version 1.0
*/
@Data
@TableName("user")
@NoArgsConstructor
@EqualsAndHashCode
public class User {
/**
* id自增
*/
@TableId(type = IdType.AUTO)
@ExcelProperty(value = "ID", index = 0)
private Integer id;
@ExcelProperty(value = "用户名", index = 1)
private String username;
@ExcelProperty(value = "密码", index = 2)
private String password;
/**
* 数据库中的nick_name会自动转换为驼峰
*/
@ExcelProperty(value = "昵称", index = 3)
private String nickName;
@ExcelProperty(value = "年龄", index = 4)
private Integer age;
@ExcelProperty(value = "性别", index = 5)
private String sex;
@ExcelProperty(value = "住址", index = 6)
private String address;
}