生成excel和csv文件

生成Excel文件

protected File tempFile(List<List<?>> rows, String fileName, String suffix) throws IOException {
        fileName = fileName + "_" + DateUtil.format(LocalDateTime.now(), DatePattern.PURE_DATETIME_MS_PATTERN);
        // 临时文件
        File tempFile = File.createTempFile(fileName, suffix);

        // 写入文件
        log.info("开始写入文件 {} ", fileName);
        BigExcelWriter writer = ExcelUtil.getBigWriter();
        writer.write(rows);
        writer.flush(Files.newOutputStream(tempFile.toPath()), true);
        writer.close();

        return tempFile;
    }

 List<List<?>> rows = new ArrayList<>();
 rows.add(Arrays.asList("a", "b", "c"));
  String suffix = ".xlsx";

生成CSV文件

 protected File tempFileCSV(List<?> rows, String fileName, String suffix) throws IOException {
        fileName = fileName + "_" + DateUtil.format(LocalDateTime.now(), DatePattern.PURE_DATETIME_MS_PATTERN);
        // 临时文件
        File tempFile = File.createTempFile(fileName, suffix);

        // 写入文件
        log.info("开始写入文件 {} ", fileName);
        CsvWriter writer = new CsvWriter(tempFile, StandardCharsets.UTF_8);
        writer.writeBeans(rows);
        writer.flush();
        writer.close();

        return tempFile;
    }



List<User> businessesInfo = userService.getUsers(query);
String suffix = ".csv";