springboot整合easyExcel实现报表导入导出

1.引入maven坐标

     <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.6</version>
   	 </dependency>

2.编写导出实体类

package com.myservice.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

/**
 * @ClassName UserEntity
 * @Description TODO
 * @Author kejj
 * @Date 2020/9/26 16:35
 * @Version 1.0
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class UserEntity {
	
    @ExcelProperty("用户名") 
    private String userName;
    @ExcelProperty("年龄")
    private int age;
    
    @ExcelProperty("生日")
    @ColumnWidth(30)  //设置行宽