easypoi导出验证及校验码认证，模板唯一认证

原创

已于 2024-02-18 15:44:24 修改 · 606 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#java #eclipse #spring

于 2024-02-18 15:43:54 首次发布

文章描述了一个基于Java的API接口实现，用于动态导出文件并确保导入文件的模板真实性、唯一性和格式正确性。同时，还涉及了文件上传、模板校验以及Excel数据处理的相关操作。

动态导出文件，客户把文件信息补充完整，导入文件时，需要校验文件的真实性及文件的唯一性，确保导入的文件是单据的！

// 动态导出文件
@ApiOperation(value = "填报登记模板下载")
    @PostMapping(value = "/xxx/templateDownLoad")
    public void download(@RequestBody String jsonString, @RequestHeader("x-user-token") String token, HttpServletResponse response) {
   
   
        // 生成初始化，list内放需要导出的数据
        List<TemplateVo> findList = new ArrayList<>();
        Model model = JSON.parseObject(jsonString, Model.class);
        String msgid = model.getMsgid();
        if (StringUtils.isEmpty(msgid)){
   
   
            logger.info("未获取到唯一标识");
            throw new BusizException("唯一标识不能为空");
        }
        // 取得sql或者业务的内容
        findList = xxxService.getAll(model);
        try {
   
   
            //设置单元格位置
            CellRangeAddress cellAddresses = new CellRangeAddress(0, 0, 0, 0);
            //1.创建excel文档对象
            XSSFWorkbook wb = new XSSFWorkbook();
            //样式
            Map<String, XSSFCellStyle> cellStyle = createCellStyle(wb);
            //2.创建sheet对象
            XSSFSheet sheet = wb.createSheet("模板");
            //创建提示标题信息
            XSSFRow row0 = sheet.createRow(0);
            createTitle(row0, cellAddresses, sheet, cellStyle,msgid);
            //3.创建表头,创建第一行
            XSSFRow row1 = sheet.createRow(1);
            createHeaders(row1, cellAddresses, sheet, cellStyle);
            //填充数据
            createDataCellFdplPlan(findList1, sheet, cellStyle);
            //设置列宽
            setColumnLength(sheet);
            // 设置日期信息
            Calendar now = Calendar.getInstance();
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            String dateNowStr = sdf.format(now.getTime());
            // 开启流
            ByteArrayOutputStream bos = new ByteArrayOutputStream();
            wb.write(bos);
            byte[] bytes = bos.toByteArray();
            bos.close();
            response.setHeader("Content-Disposition", "attachment; filename=\"iJEP_" + dateNowStr + ".xlsx\"");
            response.addHeader("Content-Length", "" + bytes.length);
            response.setContentType("application/octet-stream; charset=UTF-8");
            IOUtils.write(bytes, response.getOutputStream());
            logger.info("登记模板--附件下载完成！");
        } catch (Exception e) {
   
   
            logger.info("登记模板--附件下载失败！" + e);
        }

    }
 // 样式设计   
 private Map<String, XSSFCellStyle> createCellStyle(XSSFWorkbook wb){
   
   
        Map<String, XSSFCellStyle> styles = new HashMap();
        XSSFCellStyle style = wb.createCellStyle();
        style.setAlignment(HorizontalAlignment.CENTER);
        style.setVerticalAlignment(VerticalAlignment.CENTER);
        style.setBorderRight(BorderStyle.THIN);
        style.setRightBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
        style.setBorderLeft(BorderStyle.THIN);
        style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
        style.setBorderTop(BorderStyle.THIN);
        style.setTopBorderColor(