Excel导出

EasyExcel

OutputStream outputStream=null;
        try {
            response.setCharacterEncoding("utf-8");
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setHeader("Access-Control-Allow-Origin", "*");
            String fileName = null;
            fileName = URLEncoder.encode("template", "UTF-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
            response.setHeader("attName", fileName);
            response.setHeader("Access-Control-Expose-Headers", "attName");
            response.addHeader("Access-Control-Expose-Headers", "Content-Disposition");
            outputStream=response.getOutputStream();
        } catch (IOException e) {
            e.printStackTrace();
        }

ExcelWriter excelWriter = EasyExcel.write(outputStream).build();
        WriteSheet sheet1 = EasyExcel.writerSheet(0, "精磨记录表").head(FineGrindingExcel.class).build();
        excelWriter.write(fineGrindingExcelList, sheet1);
        WriteSheet sheet2 = EasyExcel.writerSheet(1, "BWT记录表").head(BWTProdRecordExcel.class).build();
        excelWriter.write(bwtProdRecordExcelList, sheet2);
        WriteSheet sheet3 = EasyExcel.writerSheet(2, "RA记录表").head(RAProdRecordExcel.class).build();
        excelWriter.write(raProdRecordExcelList, sheet3);
        WriteSheet sheet4 = EasyExcel.writerSheet(3, "质量记录表").head(QualityProdRecordExcel.class).build();
        excelWriter.write(qualityProdRecordExcelList, sheet4);
        excelWriter.finish();

EasyExcel使用详情

EasyPoi使用详情