springboot使用aspose预览office文件

男娘i 2022-10-05 04:44 287阅读 0赞

springboot项目使用aspose预览office文件，运行实现预览效果：

![20210606144718846.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 3][]

主要实现原理是：浏览器可以直接预览pdf,所以使用aspose把office文件转换为pdf文件，进行预览。

1.主要写了个简单的demo,项目目录:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 4][]

2.pom.xml添加aspose的依赖包（目前maven仓库不提供以下aspose的依赖包，可以自行下载添加进maven仓库，或者直接拉到最下面下载本人demo，demo提供了相应的jar包）

<dependency>
                <groupId>com.aspose</groupId>
                <artifactId>aspose-slides</artifactId>
                <version>19.3</version>
            </dependency>
            <dependency>
                <groupId>com.aspose</groupId>
                <artifactId>aspose-cells</artifactId>
                <version>8.5.2</version>
            </dependency>
            <dependency>
                <groupId>com.aspose</groupId>
                <artifactId>aspose-words</artifactId>
                <version>15.8.0</version>
            </dependency>

![20210606145859886.png][]

把jar包放在d盘，然后cmd，执行命令把jar包加进maven仓库

mvn install:install-file -Dfile=D:\jar\aspose-words-15.8.0.jar -DgroupId=com.aspose -DartifactId=aspose-words -Dversion=15.8.0 -Dpackaging=jar
    
    
    mvn install:install-file -Dfile=D:\jar\aspose-cells-8.5.2.jar -DgroupId=com.aspose -DartifactId=aspose-cells -Dversion=8.5.2 -Dpackaging=jar
    
    
    mvn install:install-file -Dfile=D:\jar\aspose.slides-19.3.jar -DgroupId=com.aspose -DartifactId=aspose-slides -Dversion=19.3 -Dpackaging=jar

3.后端主要代码：

@Controller
    public class FileController {
    
        @Autowired
        private FileToPdfComUtils fileToPdfComUtils;
    
        /**
         * index页面
         * @return
         */
        @GetMapping("/index")
        public String index(){
            return "index";
        }
    
        /**
         * 文件预览
         * @param filePath
         * @param request
         * @param response
         * @throws IOException
         */
        @GetMapping("/showFile")
        @ResponseBody
        public void showFile(String filePath, HttpServletRequest request, HttpServletResponse response) throws IOException {
            //源文件路径
            String sourcePath = filePath;
            //pdf文件路径
            String pdfPath = null;
            //获取文件后缀判断是否转换pdf
            int index = filePath.lastIndexOf(".");
            String fileType = filePath.substring(index + 1);
            String toPdfSuffix = "doc,docx,xls,xlsx,ppt,pptx";
            try {
                if(toPdfSuffix.indexOf(fileType) >= 0){
                    pdfPath = sourcePath.substring(0, index) + ".pdf";
                    //源文件转换pdf
                    fileToPdfComUtils.officeToPdf(sourcePath, pdfPath);
                    File pdfFile = new File(pdfPath);
                    InputStream is = new FileInputStream(pdfFile);
                    showPdf(is, pdfPath, request, response);
                } else {
                    //不用转换，直接预览
                    File pdfFile = new File(filePath);
                    InputStream is = new FileInputStream(pdfFile);
                    showPdf(is,filePath, request, response);
                }
            }catch (Exception e){
                e.printStackTrace();
            } finally {
                //最后删除生成的pdf文件
                FileUtils.deleteFile(pdfPath);
            }
    
        }
    
        /**
         * 文件预览
         * @param is
         * @param fileKey
         * @param request
         * @param response
         * @throws IOException
         */
        public void showPdf(InputStream is,  String fileKey, HttpServletRequest request, HttpServletResponse response) throws IOException {
            //根据文件名获取 MIME 类型
            int idx = fileKey.lastIndexOf(".");
            String suffix = fileKey.substring(idx);
            String[] fileKeys = fileKey.split("/");
            String fileName = fileKeys[fileKeys.length - 1];
            String contentType = FileContentType.SUFFIX_TYPE.get(suffix);
            //inline表示直接预览
            String userAgent = request.getHeader("USER-AGENT");
            String contentDisposition = "";
            if(StringUtils.contains(userAgent, "MSIE")||StringUtils.contains(userAgent, "Trident") || StringUtils.contains(userAgent,"Edge")){
                //IE 浏览器
                contentDisposition = "inline;filename=" + URLEncoder.encode(fileName,"UTF8");
            }else {
                //其他浏览器
                contentDisposition = "inline;filename=" + new String(fileName.getBytes("UTF-8"),"ISO8859-1");
            }
            // 设置头
            response.setHeader("Content-Disposition",contentDisposition);
            response.setContentType(contentType);
            // 获取绑定了客户端的流
            ServletOutputStream output = response.getOutputStream();
            // 把输入流中的数据写入到输出流中
            IOUtils.copy(is,output);
            is.close();
        }
    }

4.前端代码：

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>预览文件</title>
    </head>
    <body>
    <button target="_blank" type="button"
            onclick="showFile('d:/file/测试.doc')">预览doc </button>
    <button  target="_blank" type="button"
            onclick="showFile('d:/file/测试.docx')">预览docx </button>
    <button  target="_blank" type="button"
            onclick="showFile('d:/file/测试.xls')">预览xls </button>
    <button target="_blank" type="button"
            onclick="showFile('d:/file/测试.xlsx')">预览xlsx </button>
    <button  target="_blank" type="button"
            onclick="showFile('d:/file/测试.pptx')">预览pptx </button>
    <button  target="_blank" type="button"
            onclick="showFile('d:/file/数据库原理（第5版）（样章）.pdf')">预览pdf </button>
    <script>
        //预览
        function showFile (filePath){
            var url = "/showFile" + "?filePath=" + filePath;
            window.open(url);
        };
    
    </script>
    </body>
    </html>

5.本人文件目录：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 5][]

6.下载demo:

[https://download.csdn.net/download/weixin\_39220472/19418676][https_download.csdn.net_download_weixin_39220472_19418676]

[20210606144718846.png]: /images/20221005/7ef8f69b491c4aeb8d5426a0f12cbb50.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70]: /images/20221005/64e53bb8cad244a18c78ff834346a9fc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 1]: /images/20221005/6ce762d73dda4bd9850f767928c1ca2b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 2]: /images/20221005/acb26a42b5a744e08648be382bfc409e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 3]: /images/20221005/75b65a1067014d27a47679168013aea8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 4]: /images/20221005/b927c56334324a9fb113066c42670d5a.png
[20210606145859886.png]: /images/20221005/6f23a31fabdd46eb9f03dc9b9363f91d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTIyMDQ3Mg_size_16_color_FFFFFF_t_70 5]: /images/20221005/7e4f7c01e8d54145bae2be9225da8bfe.png
[https_download.csdn.net_download_weixin_39220472_19418676]: https://download.csdn.net/download/weixin_39220472/19418676