easyExcel

@Data
public class User implements Serializable {

    @ExcelProperty(value = "name")
    private String name;

    @ExcelProperty(value = "age")
    private String age;

}
1 写
public void test(HttpServletResponse response）{
       List<User> data = new ArrayList<User>();
       EasyExcel.write(response.getOutputStream(), User.class).sheet("模板").doWrite(data);
}


2 读

public class DemoExcelListner extends AnalysisEventListener<User> {
    @Override
    public void invoke(User excelModel, AnalysisContext analysisContext) {
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {

    }
}

EasyExcel.read(file.getInputStream(), USer.class,new DemoExcelListner() ).sheet().doReadSync();