<dependency>
 ? ? <groupId>com.alibaba</groupId>
 ? ? <artifactId>easyexcel</artifactId>
 ? ? <version>2.2.8</version>
</dependency>

<dependency>
 ? ? <groupId>org.apache.poi</groupId>
 ? ? <artifactId>poi</artifactId>
 ? ? <version>3.17</version>
</dependency>
<dependency>
 ? ? <groupId>org.apache.poi</groupId>
 ? ? <artifactId>poi-ooxml</artifactId>
 ? ? <version>3.17</version>
</dependency>

@Data
public class UserData {
?
  @ExcelProperty(index = 0, value = "姓名")
  private String username;
?
  @ExcelProperty(index = 1, value = "年齡")
  private int age;
?
  @DateTimeFormat("yyyy-MM-dd")
  @ExcelProperty(index = 2, value = "生日")
  private Date birthday;
}

public class EasyExcelDemo {
  public static void main(String[] args) {
    // 實(shí)現(xiàn)excel寫操作
    //1.設(shè)置寫入文件夾地址和excel文件名稱
    String fileName = "/Users/zzs/temp/excel/write.xlsx";
    //調(diào)用easyExcel里面的方法實(shí)現(xiàn)寫操作
    //2個(gè)參數(shù)，第一個(gè)參數(shù)是文件名稱，第二個(gè)參數(shù)是實(shí)體類
    EasyExcel.write(fileName, UserData.class).sheet("學(xué)生信息表").doWrite(getData());
  }
?
  //創(chuàng)建方法返回list集合
  public static List<UserData> getData() {
    List<UserData> list = new ArrayList<>();
?
    UserData userData1 = new UserData();
    userData1.setUsername("張三");
    userData1.setAge(22);
    userData1.setBirthday(formatDate("2000-10-11"));
    list.add(userData1);
?
    UserData userData2 = new UserData();
    userData2.setUsername("李四");
    userData2.setAge(23);
    userData2.setBirthday(formatDate("1999-5-3"));
    list.add(userData2);
    return list;
  }
  public static Date formatDate(String birthday) {
    SimpleDateFormat sdf = new SimpleDateFormat("yyy-MM-dd");
    try {
      return sdf.parse(birthday);
    } catch (ParseException e) {
      e.printStackTrace();
    }
    return null;
  }
}

public class ExcelListener extends AnalysisEventListener<UserData> {
  /**
   * 一行一行的讀取excel內(nèi)容
   */
  @Override
  public void invoke(UserData data, AnalysisContext analysisContext) {
    System.out.println("****" + data);
  }

  /**
   * 讀取表頭內(nèi)容
   */
  @Override
  public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
    System.out.println("表頭" + headMap);
  }
  /**
   * 讀取完成操作
   */
  @Override
  public void doAfterAllAnalysed(AnalysisContext analysisContext) {
    System.out.println("讀取Excel完畢");
  }
}

public class EasyExcelReadDemo {

  public static void main(String[] args) {
    // 實(shí)現(xiàn)excel寫操作
    //1.設(shè)置寫入文件夾地址和excel文件名稱
    String fileName = "/Users/zzs/temp/excel/write.xlsx";
    //調(diào)用easyExcel里面的方法實(shí)現(xiàn)寫操作
    //2個(gè)參數(shù)，第一個(gè)參數(shù)是文件名稱，第二個(gè)參數(shù)是實(shí)體類
    EasyExcel.read(fileName, UserData.class, new ExcelListener()).sheet().doRead();
  }
}

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.property.ExcelContentProperty;

public class SexConverter implements Converter<Integer> {

 ?  @Override
 ?  public Class<Integer> supportJavaTypeKey() {
 ? ? ?  return Integer.class;
 ?  }

 ?  @Override
 ?  public CellDataTypeEnum supportExcelTypeKey() {
 ? ? ?  return CellDataTypeEnum.STRING;
 ?  }

 ?  @Override
 ?  public Integer convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
 ? ? ?  return "男".equals(cellData.getStringValue()) ? 1 : 0;
 ?  }

 ?  @Override
 ?  public CellData<String> convertToExcelData(Integer integer, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
 ? ? ?  return new CellData<>(integer.equals(1) ? "男" : "女");
 ?  }
}

@ExcelProperty(value = "性別", converter = SexConverter.class)
private Integer sex;

@ExcelProperty(value = "體重KG")
@NumberFormat("0.##") // 會(huì)以字符串形式生成單元格，要計(jì)算的列不推薦
private BigDecimal weight;

@ContentStyle(dataFormat = 2)
private BigDecimal weight2;

@Data
@ToString
@AllArgsConstructor
@NoArgsConstructor  // 一定要有無(wú)參構(gòu)造方法
@ExcelIgnoreUnannotated
public class UserData {
 ?  .....
}

@ExcelIgnore // 該字段不生成excel
private String remark;

    EasyExcel.write(fileName, UserData.class).sheet("學(xué)生信息表").excludeColumnFiledNames(Arrays.asList("remark")).doWrite(getData());