fix:优化xls在web端预览失败的问题

许鹏程

2025-05-19 c356c77683d055f82a668c28db8b56f9c5e04b84

fix:优化xls在web端预览失败的问题

 src/main/java/com/product/file/service/FileManagerService.java

@@ -18,6 +18,7 @@
import com.product.core.spring.context.SpringMVCContextHolder;
import com.product.file.config.CmnConst;
import com.product.file.config.FileCode;
import com.product.file.util.AsposeUtil;
import com.product.file.util.CreateDocumentIndexThread;
import com.product.file.util.FileUtil;
import com.product.file.util.FileUtils;
@@ -445,6 +446,7 @@
            }
        }
    }

    /**
     * 移动端升级，安装包下载
     *
@@ -584,6 +586,7 @@
        }
    
    }

    /**
     * 提取文件信息-下载文件或者在线预览文件
     *
@@ -656,6 +659,19 @@
                    tempOs.flush();
                    tempOs.close();
                }
                boolean delete = false;
                if (realFileName.endsWith(".xls") && needOnlineViewFlag && localTempFile.exists() && !CoreConst.CLIENT_TYPE_APP.equals(clientType)) {
                    //转换为xlsx
                    AsposeUtil.xls2xlsx(localTempFile.getPath(), getSystemConfig("temp.dir", "/attachment/temp") + "/" + localTempFile.getName(), "xls");
                    File oldFile = localTempFile;
                    localTempFile = new File(getSystemConfig("temp.dir", "/attachment/temp") + "/" + localTempFile.getName());
                    if (!localTempFile.isFile()) {
                        localTempFile = oldFile;
                    } else {
                        delete = true;
                        oldFile.delete();
                    }
                }
                response.setContentLengthLong(localTempFile.length());
                InputStream is = new FileInputStream(localTempFile);
                int len;
@@ -695,6 +711,18 @@
                FileUtils.convertPdf(false, false, encrptSignFlag, true, tempSourceFile, dir, fileName, attachmentFse.getString(CmnConst.FILE_NAME));
                tempSourceFile.delete();
            }
            boolean delete = false;
            if (realFileName.endsWith(".xls") && needOnlineViewFlag && file.exists() && !CoreConst.CLIENT_TYPE_APP.equals(clientType)) {
                //转换为xlsx
                AsposeUtil.xls2xlsx(file.getPath(), getSystemConfig("temp.dir", "/attachment/temp") + "/" + file.getName(), "xls");
                File oldFile = file;
                file = new File(getSystemConfig("temp.dir", "/attachment/temp") + "/" + file.getName());
                if (!file.isFile()) {
                    file = oldFile;
                } else {
                    delete = true;
                }
            }
            int len;
            byte[] b = new byte[1024];
            InputStream is = new FileInputStream(file);
@@ -717,6 +745,9 @@
                os.flush();
            }
            is.close();
            if (delete) {
                file.delete();
            }
        }
        logger.info("文件流获取成功");
    }