@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();
easyExcel
最新推荐文章于 2024-04-03 18:45:57 发布