下载excel

 docker kill report-word-test

Error response from daemon: Cannot kill container: report-word-test: Container 409c731698a108e953d5114c9a8ec470a362ed094d784a604e04373ace788649 is not running
 

docker rm -f 409c731698a108e953d5114c9a8ec470a362ed094d784a604e04373ace788649

下载excel

   @GetMapping("/export")
    public ResponseEntity<byte[]> exportEnterpriseReportsToExcel() throws IOException {
          final DateTimeFormatter DATE_TIME_FORMATTER = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

        // 创建 Excel 工作簿
        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet("企业年报信息");
        // 创建表头
        Row headerRow = sheet.createRow(0);
        String[] headers = {"企业信用代码", "企业名称", "年份", "年报名称", "解析状态","抽取日期"};
        for (int i = 0; i < headers.length; i++) {
            Cell cell = headerRow.createCell(i);
            cell.setCellValue(headers[i]);
        }
        List<DbTask> tasks = taskService.list(Wrappers.lambdaQuery(DbTask.class)
//                .eq(DbTask::getFileStatus, FileStatusEnum.FILE_FAIL.getCode())
                .eq(DbTask::getYear, "2023")
                .gt(DbTask::getCreateTime, "2025-01-22"));
        // 填充数据
        for (int i = 0; i < tasks.size(); i++) {
            DbTask report = tasks.get(i);
            Row row = sheet.createRow(i + 1);
            row.createCell(0).setCellValue(report.getCompanyCode());
            row.createCell(1).setCellValue(report.getName());
            row.createCell(2).setCellValue(report.getYear());
            row.createCell(3).setCellValue(report.getName());
            row.createCell(4).setCellValue(FileStatusEnum.getDesc(report.getFileStatus()));

            if (report.getCreateTime() != null) {
                row.createCell(5).setCellValue(report.getCreateTime().format(DATE_TIME_FORMATTER));
            }

        }
        // 自动调整列宽
        for (int i = 0; i < headers.length; i++) {
            sheet.autoSizeColumn(i);
        }
        // 将工作簿写入字节数组输出流
        ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
        workbook.write(outputStream);
        workbook.close();
        // 设置响应头
        HttpHeaders headersResponse = new HttpHeaders();
        headersResponse.setContentType(MediaType.APPLICATION_OCTET_STREAM);
        headersResponse.setContentDispositionFormData("attachment", "users.xlsx");
        // 返回响应
        return new ResponseEntity<>(outputStream.toByteArray(), headersResponse, HttpStatus.OK);
    }