package com.platform.service.impl; import com.platform.service.AnalysisService; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.stereotype.Service; import org.springframework.web.multipart.MultipartFile; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.nio.file.Files; import java.nio.file.Path; import java.nio.file.StandardCopyOption; import java.util.ArrayList; import java.util.List; import java.util.zip.ZipEntry; import java.util.zip.ZipInputStream; /** * @author : wujipeng * @date : 2025/7/30 11:48 * @Version: 1.0 * @Desc : 描述信息 */ @Service public class AnalysisServiceImpl implements AnalysisService { private static final String[] EXCEL_EXTENSIONS = {".xlsx", ".xls"}; @Override public Object canvas(MultipartFile file) { try { if (file.isEmpty()) { return "上传的文件为空"; } // // 检查是否是ZIP文件 // if (file.getOriginalFilename().toLowerCase().endsWith(".zip")) { // List excelFiles = extractExcelFilesFromZip(file); // return processExcelFiles(excelFiles); // } // 检查是否是Excel文件 else if (isExcelFile(file.getOriginalFilename())) { File tempFile = convertMultipartFileToFile(file); return processSingleExcelFile(tempFile); } // 检查是否是目录(通过检查是否没有扩展名) else if (isLikelyDirectory(file.getOriginalFilename())) { // 保存上传的临时文件 Path tempDir = createTempDirectory(); Path uploadedFile = tempDir.resolve(file.getOriginalFilename()); Files.copy(file.getInputStream(), uploadedFile, StandardCopyOption.REPLACE_EXISTING); // 处理目录 List excelFiles = new ArrayList<>(); if (Files.isDirectory(uploadedFile)) { // 如果是目录,遍历其中的文件 Files.walk(uploadedFile) .filter(Files::isRegularFile) .filter(path -> isExcelFile(path.getFileName().toString())) .forEach(path -> excelFiles.add(path.toFile())); } else { // 如果是文件,检查是否是Excel文件 if (isExcelFile(uploadedFile.getFileName().toString())) { excelFiles.add(uploadedFile.toFile()); } } return processExcelFiles(excelFiles); } else { return "不支持的文件类型,请上传Excel文件(.xlsx, .xls)、文件夹或包含Excel文件的ZIP文件夹"; } } catch (Exception e) { e.printStackTrace(); return "文件处理失败: " + e.getMessage(); } } private boolean isLikelyDirectory(String filename) { if (filename == null) return false; String lowerCaseFilename = filename.toLowerCase(); for (String extension : EXCEL_EXTENSIONS) { if (lowerCaseFilename.endsWith(extension)) { return false; } } return !lowerCaseFilename.contains("."); } // 检查是否是Excel文件 private boolean isExcelFile(String filename) { if (filename == null) return false; String lowerCaseFilename = filename.toLowerCase(); for (String extension : EXCEL_EXTENSIONS) { if (lowerCaseFilename.endsWith(extension)) { return true; } } return false; } // 从ZIP文件中提取Excel文件 private List extractExcelFilesFromZip(MultipartFile zipFile) throws IOException { List excelFiles = new ArrayList<>(); File tempDir = createTempDirectory().toFile(); try (ZipInputStream zipIn = new ZipInputStream(zipFile.getInputStream())) { ZipEntry entry = zipIn.getNextEntry(); while (entry != null) { if (!entry.isDirectory()) { String fileName = entry.getName(); if (isExcelFile(fileName)) { // 处理可能存在的路径问题 File tempFile = new File(tempDir, new File(fileName).getName()); try (FileOutputStream fos = new FileOutputStream(tempFile)) { byte[] buffer = new byte[1024]; int len; while ((len = zipIn.read(buffer)) > 0) { fos.write(buffer, 0, len); } } excelFiles.add(tempFile); } } zipIn.closeEntry(); entry = zipIn.getNextEntry(); } } return excelFiles; } // 处理多个Excel文件 private String processExcelFiles(List excelFiles) throws IOException { if (excelFiles.isEmpty()) { return "未找到任何Excel文件"; } StringBuilder result = new StringBuilder(); result.append("共找到 ").append(excelFiles.size()).append(" 个Excel文件:\n"); for (File excelFile : excelFiles) { result.append("处理文件: ").append(excelFile.getName()).append("\n"); String fileContent = readExcelFile(excelFile); result.append(fileContent).append("\n\n"); // 删除临时文件 if (!excelFile.delete()) { excelFile.deleteOnExit(); } } return result.toString(); } // 处理单个Excel文件 private String processSingleExcelFile(File excelFile) throws IOException { //读取第一个sheet Sheet sheet = getWorkbook(excelFile).getSheetAt(0); //获取文件表头 Row headerRow = sheet.getRow(0); List headers = new ArrayList<>(); for (Cell cell : headerRow) { headers.add(getCellValueAsString(cell)); } String content = readExcelFile(excelFile); if (!excelFile.delete()) { excelFile.deleteOnExit(); } return "处理单个Excel文件:\n" + content; } // 读取Excel文件内容 private String readExcelFile(File excelFile) throws IOException { StringBuilder content = new StringBuilder(); try (Workbook workbook = getWorkbook(excelFile)) { for (int i = 0; i < workbook.getNumberOfSheets(); i++) { Sheet sheet = workbook.getSheetAt(i); content.append("工作表: ").append(sheet.getSheetName()).append("\n"); for (Row row : sheet) { for (Cell cell : row) { content.append(getCellValueAsString(cell)).append("\t"); } content.append("\n"); } content.append("\n"); } } return content.toString(); } // 根据文件类型创建Workbook private Workbook getWorkbook(File excelFile) throws IOException { String fileName = excelFile.getName().toLowerCase(); if (fileName.endsWith(".xlsx")) { return new XSSFWorkbook(new FileInputStream(excelFile)); } else if (fileName.endsWith(".xls")) { return new HSSFWorkbook(new FileInputStream(excelFile)); } else { throw new IllegalArgumentException("不支持的Excel文件格式"); } } // 获取单元格值作为字符串 private String getCellValueAsString(Cell cell) { if (cell == null) { return ""; } switch (cell.getCellType()) { case STRING: return cell.getStringCellValue(); case NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { return cell.getLocalDateTimeCellValue().toString(); } else { return String.valueOf(cell.getNumericCellValue()); } case BOOLEAN: return String.valueOf(cell.getBooleanCellValue()); case FORMULA: return cell.getCellFormula(); case BLANK: return ""; default: return cell.toString(); } } // 创建临时目录 private Path createTempDirectory() throws IOException { return Files.createTempDirectory("excel-upload-"); } // 将MultipartFile转换为File private File convertMultipartFileToFile(MultipartFile file) throws IOException { File convFile = new File(System.getProperty("java.io.tmpdir") + "/" + file.getOriginalFilename()); file.transferTo(convFile); return convFile; } }