EasyExcel - Excel处理工具新手入门指南

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

@Datapublic class DemoData {    @ExcelProperty("字符串标题")    private String string;    @ExcelProperty("日期标题")    private Date date;    @ExcelProperty("数字标题")    private Double doubleData;}

// 定义监听器public class DemoDataListener extends AnalysisEventListener<DemoData> {    private List<DemoData> list = new ArrayList<>();    @Override    public void invoke(DemoData data, AnalysisContext context) {        list.add(data);    }    @Override    public void doAfterAllAnalysed(AnalysisContext context) {        // 读取完成后的操作        saveData();    }    private void saveData() {        // 保存数据到数据库    }}// 读取 ExcelString fileName = "demo.xlsx";EasyExcel.read(fileName, DemoData.class, new DemoDataListener()).sheet().doRead();

String fileName = "output.xlsx";EasyExcel.write(fileName, DemoData.class)    .sheet("模板")    .doWrite(dataList);

@GetMapping("download")public void download(HttpServletResponse response) throws IOException {    response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");    response.setCharacterEncoding("utf-8");    String fileName = URLEncoder.encode("测试", "UTF-8").replaceAll("\\+", "%20");    response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");    EasyExcel.write(response.getOutputStream(), DemoData.class)        .sheet("模板")        .doWrite(dataList());}

@PostMapping("upload")@ResponseBodypublic String upload(MultipartFile file) throws IOException {    EasyExcel.read(file.getInputStream(), DemoData.class, new DemoDataListener())        .sheet()        .doRead();    return "success";}

@ExcelProperty(value = "标题", index = 0)@ContentStyle(horizontalAlignment = HorizontalAlignment.CENTER)private String title;