devbox
小丑西瓜9
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Springboot整合openoffice实现文件在线预览_openoffice 在线预览

作者：小丑西瓜9 | 2024-04-09 13:03:08

赞

踩

openoffice 在线预览

一 下载安装openoffice

https://www.openoffice.org/download/icon-default.png?t=N7T8https://www.openoffice.org/download/

我这里使用4.1.10 windows版本 

下载完后启动服务

运行→cmd，输入：

cd C:\Program Files (x86)\OpenOffice 4\program

回车

再输入

soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;" -nofirststartwizard

回车

二 springboot整合

1.引入依赖

  1.         <dependency>
  2.             <groupId>com.artofsolving</groupId>
  3.             <artifactId>jodconverter</artifactId>
  4.             <version>2.2.1</version>
  5.         </dependency>
  6.         <dependency>
  7.             <groupId>org.apache.commons</groupId>
  8.             <artifactId>commons-lang3</artifactId>
  9.             <version>3.7</version>
  10.         </dependency>

2.编写文件格式转换工具类

  1. package com.lzl.util;
  2.  
  3. import com.artofsolving.jodconverter.DefaultDocumentFormatRegistry;
  4. import com.artofsolving.jodconverter.DocumentConverter;
  5. import com.artofsolving.jodconverter.DocumentFormat;
  6. import com.artofsolving.jodconverter.openoffice.connection.OpenOfficeConnection;
  7. import com.artofsolving.jodconverter.openoffice.connection.SocketOpenOfficeConnection;
  8. import com.artofsolving.jodconverter.openoffice.converter.StreamOpenOfficeDocumentConverter;
  9.  
  10. import java.io.*;
  11. import java.net.HttpURLConnection;
  12. import java.net.URL;
  13. import java.net.URLConnection;
  14.  
  15. /**
  16.  * 文件格式转换工具类
  17.  */
  18. public class FileConvertUtil {
  19.  
  20.     /**
  21.      * 默认转换后文件后缀
  22.      */
  23.     private static final String DEFAULT_SUFFIX = "pdf";
  24.     /**
  25.      * openoffice_port
  26.      */
  27.     private static final Integer OPENOFFICE_PORT = 8100;
  28.  
  29.     /**
  30.      * 方法描述 office文档转换为PDF(处理本地文件)
  31.      * @param sourcePath 源文件路径
  32.      * @param suffix     源文件后缀
  33.      * @return InputStream 转换后文件输入流
  34.      */
  35.     public static InputStream convertLocaleFile(String sourcePath, String suffix) throws Exception {
  36.         File inputFile = new File(sourcePath);
  37.         InputStream inputStream = new FileInputStream(inputFile);
  38.         return covertCommonByStream(inputStream, suffix);
  39.     }
  40.  
  41.     /**
  42.      * 方法描述  office文档转换为PDF(处理网络文件)
  43.      * @param netFileUrl 网络文件路径
  44.      * @param suffix     文件后缀
  45.      * @return InputStream 转换后文件输入流
  46.      */
  47.     public static InputStream convertNetFile(String netFileUrl, String suffix) throws Exception {
  48.         // 创建URL
  49.         URL url = new URL(netFileUrl);
  50.         // 试图连接并取得返回状态码
  51.         URLConnection urlconn = url.openConnection();
  52.         urlconn.connect();
  53.         HttpURLConnection httpconn = (HttpURLConnection) urlconn;
  54.         int httpResult = httpconn.getResponseCode();
  55.         if (httpResult == HttpURLConnection.HTTP_OK) {
  56.             InputStream inputStream = urlconn.getInputStream();
  57.             return covertCommonByStream(inputStream, suffix);
  58.         }
  59.         return null;
  60.     }
  61.  
  62.     /**
  63.      * 方法描述  将文件以流的形式转换
  64.      *
  65.      * @param inputStream 源文件输入流
  66.      * @param suffix      源文件后缀
  67.      * @return InputStream 转换后文件输入流
  68.      */
  69.     public static InputStream covertCommonByStream(InputStream inputStream, String suffix) throws Exception {
  70.         ByteArrayOutputStream out = new ByteArrayOutputStream();
  71.         OpenOfficeConnection connection = new SocketOpenOfficeConnection(OPENOFFICE_PORT);
  72.         connection.connect();
  73.         DocumentConverter converter = new StreamOpenOfficeDocumentConverter(connection);
  74.         DefaultDocumentFormatRegistry formatReg = new DefaultDocumentFormatRegistry();
  75.         DocumentFormat targetFormat = formatReg.getFormatByFileExtension(DEFAULT_SUFFIX);
  76.         DocumentFormat sourceFormat = formatReg.getFormatByFileExtension(suffix);
  77.         converter.convert(inputStream, sourceFormat, out, targetFormat);
  78.         connection.disconnect();
  79.         return outputStreamConvertInputStream(out);
  80.     }
  81.  
  82.     /**
  83.      * 方法描述 outputStream转inputStream
  84.      */
  85.     public static ByteArrayInputStream outputStreamConvertInputStream(final OutputStream out) throws Exception {
  86.         ByteArrayOutputStream baos = (ByteArrayOutputStream) out;
  87.         return new ByteArrayInputStream(baos.toByteArray());
  88.     }
  89.  
  90. }

3.编写工具类

  1. package com.lzl.util;
  2.  
  3. import org.apache.commons.lang3.StringUtils;
  4.  
  5. import java.util.ArrayList;
  6. import java.util.HashSet;
  7. import java.util.List;
  8. import java.util.Set;
  9.  
  10. public class SmartStringUtil extends StringUtils {
  11.  
  12.     // ===============split =======================
  13.  
  14.     public static Set<String> splitConvertToSet(String str, String split) {
  15.         if (isEmpty(str)) {
  16.             return new HashSet<String>();
  17.         }
  18.         String[] splitArr = str.split(split);
  19.         HashSet<String> set = new HashSet<String>(splitArr.length);
  20.         for (String string : splitArr) {
  21.             set.add(string);
  22.         }
  23.         return set;
  24.     }
  25.  
  26.     public static List<String> splitConvertToList(String str, String split) {
  27.         if (isEmpty(str)) {
  28.             return new ArrayList<String>();
  29.         }
  30.         String[] splitArr = str.split(split);
  31.         ArrayList<String> list = new ArrayList<String>(splitArr.length);
  32.         for (String string : splitArr) {
  33.             list.add(string);
  34.         }
  35.         return list;
  36.     }
  37.  
  38.     // ===============split Integer=======================
  39.  
  40.     public static List<Integer> splitConverToIntList(String str, String split, int defaultVal) {
  41.         if (isEmpty(str)) {
  42.             return new ArrayList<Integer>();
  43.         }
  44.         String[] strArr = str.split(split);
  45.         List<Integer> list = new ArrayList<Integer>(strArr.length);
  46.         for (int i = 0; i < strArr.length; i++) {
  47.             try {
  48.                 int parseInt = Integer.parseInt(strArr[i]);
  49.                 list.add(parseInt);
  50.             } catch (NumberFormatException e) {
  51.                 list.add(defaultVal);
  52.                 continue;
  53.             }
  54.         }
  55.         return list;
  56.     }
  57.  
  58.     public static Set<Integer> splitConverToIntSet(String str, String split, int defaultVal) {
  59.         if (isEmpty(str)) {
  60.             return new HashSet<Integer>();
  61.         }
  62.         String[] strArr = str.split(split);
  63.         HashSet<Integer> set = new HashSet<Integer>(strArr.length);
  64.         for (int i = 0; i < strArr.length; i++) {
  65.             try {
  66.                 int parseInt = Integer.parseInt(strArr[i]);
  67.                 set.add(parseInt);
  68.             } catch (NumberFormatException e) {
  69.                 set.add(defaultVal);
  70.                 continue;
  71.             }
  72.         }
  73.         return set;
  74.     }
  75.  
  76.     public static Set<Integer> splitConverToIntSet(String str, String split) {
  77.         return splitConverToIntSet(str, split, 0);
  78.     }
  79.  
  80.     public static List<Integer> splitConverToIntList(String str, String split) {
  81.         return splitConverToIntList(str, split, 0);
  82.     }
  83.  
  84.     public static int[] splitConvertToIntArray(String str, String split, int defaultVal) {
  85.         if (isEmpty(str)) {
  86.             return new int[0];
  87.         }
  88.         String[] strArr = str.split(split);
  89.         int[] result = new int[strArr.length];
  90.         for (int i = 0; i < strArr.length; i++) {
  91.             try {
  92.                 result[i] = Integer.parseInt(strArr[i]);
  93.             } catch (NumberFormatException e) {
  94.                 result[i] = defaultVal;
  95.                 continue;
  96.             }
  97.         }
  98.         return result;
  99.     }
  100.  
  101.     public static int[] splitConvertToIntArray(String str, String split) {
  102.         return splitConvertToIntArray(str, split, 0);
  103.     }
  104.  
  105.     // ===============split 2 Long=======================
  106.  
  107.     public static List<Long> splitConverToLongList(String str, String split, long defaultVal) {
  108.         if (isEmpty(str)) {
  109.             return new ArrayList<Long>();
  110.         }
  111.         String[] strArr = str.split(split);
  112.         List<Long> list = new ArrayList<Long>(strArr.length);
  113.         for (int i = 0; i < strArr.length; i++) {
  114.             try {
  115.                 long parseLong = Long.parseLong(strArr[i]);
  116.                 list.add(parseLong);
  117.             } catch (NumberFormatException e) {
  118.                 list.add(defaultVal);
  119.                 continue;
  120.             }
  121.         }
  122.         return list;
  123.     }
  124.  
  125.     public static List<Long> splitConverToLongList(String str, String split) {
  126.         return splitConverToLongList(str, split, 0L);
  127.     }
  128.  
  129.     public static long[] splitConvertToLongArray(String str, String split, long defaultVal) {
  130.         if (isEmpty(str)) {
  131.             return new long[0];
  132.         }
  133.         String[] strArr = str.split(split);
  134.         long[] result = new long[strArr.length];
  135.         for (int i = 0; i < strArr.length; i++) {
  136.             try {
  137.                 result[i] = Long.parseLong(strArr[i]);
  138.             } catch (NumberFormatException e) {
  139.                 result[i] = defaultVal;
  140.                 continue;
  141.             }
  142.         }
  143.         return result;
  144.     }
  145.  
  146.     public static long[] splitConvertToLongArray(String str, String split) {
  147.         return splitConvertToLongArray(str, split, 0L);
  148.     }
  149.  
  150.     // ===============split convert byte=======================
  151.  
  152.     public static List<Byte> splitConverToByteList(String str, String split, byte defaultVal) {
  153.         if (isEmpty(str)) {
  154.             return new ArrayList<Byte>();
  155.         }
  156.         String[] strArr = str.split(split);
  157.         List<Byte> list = new ArrayList<Byte>(strArr.length);
  158.         for (int i = 0; i < strArr.length; i++) {
  159.             try {
  160.                 byte parseByte = Byte.parseByte(strArr[i]);
  161.                 list.add(parseByte);
  162.             } catch (NumberFormatException e) {
  163.                 list.add(defaultVal);
  164.                 continue;
  165.             }
  166.         }
  167.         return list;
  168.     }
  169.  
  170.     public static List<Byte> splitConverToByteList(String str, String split) {
  171.         return splitConverToByteList(str, split, (byte) 0);
  172.     }
  173.  
  174.     public static byte[] splitConvertToByteArray(String str, String split, byte defaultVal) {
  175.         if (isEmpty(str)) {
  176.             return new byte[0];
  177.         }
  178.         String[] strArr = str.split(split);
  179.         byte[] result = new byte[strArr.length];
  180.         for (int i = 0; i < strArr.length; i++) {
  181.             try {
  182.                 result[i] = Byte.parseByte(strArr[i]);
  183.             } catch (NumberFormatException e) {
  184.                 result[i] = defaultVal;
  185.                 continue;
  186.             }
  187.         }
  188.         return result;
  189.     }
  190.  
  191.     public static byte[] splitConvertToByteArray(String str, String split) {
  192.         return splitConvertToByteArray(str, split, (byte) 0);
  193.     }
  194.  
  195.     // ===============split convert double=======================
  196.  
  197.     public static List<Double> splitConverToDoubleList(String str, String split, double defaultVal) {
  198.         if (isEmpty(str)) {
  199.             return new ArrayList<Double>();
  200.         }
  201.         String[] strArr = str.split(split);
  202.         List<Double> list = new ArrayList<Double>(strArr.length);
  203.         for (int i = 0; i < strArr.length; i++) {
  204.             try {
  205.                 double parseByte = Double.parseDouble(strArr[i]);
  206.                 list.add(parseByte);
  207.             } catch (NumberFormatException e) {
  208.                 list.add(defaultVal);
  209.                 continue;
  210.             }
  211.         }
  212.         return list;
  213.     }
  214.  
  215.     public static List<Double> splitConverToDoubleList(String str, String split) {
  216.         return splitConverToDoubleList(str, split, 0);
  217.     }
  218.  
  219.     public static double[] splitConvertToDoubleArray(String str, String split, double defaultVal) {
  220.         if (isEmpty(str)) {
  221.             return new double[0];
  222.         }
  223.         String[] strArr = str.split(split);
  224.         double[] result = new double[strArr.length];
  225.         for (int i = 0; i < strArr.length; i++) {
  226.             try {
  227.                 result[i] = Double.parseDouble(strArr[i]);
  228.             } catch (NumberFormatException e) {
  229.                 result[i] = defaultVal;
  230.                 continue;
  231.             }
  232.         }
  233.         return result;
  234.     }
  235.  
  236.     public static double[] splitConvertToDoubleArray(String str, String split) {
  237.         return splitConvertToDoubleArray(str, split, 0);
  238.     }
  239.  
  240.     // ===============solit convert float=======================
  241.  
  242.     public static List<Float> splitConverToFloatList(String str, String split, float defaultVal) {
  243.         if (isEmpty(str)) {
  244.             return new ArrayList<Float>();
  245.         }
  246.         String[] strArr = str.split(split);
  247.         List<Float> list = new ArrayList<Float>(strArr.length);
  248.         for (int i = 0; i < strArr.length; i++) {
  249.             try {
  250.                 float parseByte = Float.parseFloat(strArr[i]);
  251.                 list.add(parseByte);
  252.             } catch (NumberFormatException e) {
  253.                 list.add(defaultVal);
  254.                 continue;
  255.             }
  256.         }
  257.         return list;
  258.     }
  259.  
  260.     public static List<Float> splitConverToFloatList(String str, String split) {
  261.         return splitConverToFloatList(str, split, 0f);
  262.     }
  263.  
  264.     public static float[] splitConvertToFloatArray(String str, String split, float defaultVal) {
  265.         if (isEmpty(str)) {
  266.             return new float[0];
  267.         }
  268.         String[] strArr = str.split(split);
  269.         float[] result = new float[strArr.length];
  270.         for (int i = 0; i < strArr.length; i++) {
  271.             try {
  272.                 result[i] = Float.parseFloat(strArr[i]);
  273.             } catch (NumberFormatException e) {
  274.                 result[i] = defaultVal;
  275.                 continue;
  276.             }
  277.         }
  278.         return result;
  279.     }
  280.  
  281.     public static float[] splitConvertToFloatArray(String str, String split) {
  282.         return splitConvertToFloatArray(str, split, 0f);
  283.     }
  284.  
  285.     // ===============upperCase=======================
  286.  
  287.     /**
  288.      * 将首字母大写
  289.      *
  290.      * @param str
  291.      * @return
  292.      */
  293.     public static String upperCaseFirstChar(String str) {
  294.         if (str == null || str.isEmpty()) {
  295.             return str;
  296.         }
  297.         char firstChar = str.charAt(0);
  298.         if (Character.isUpperCase(firstChar)) {
  299.             return str;
  300.         }
  301.         char[] values = str.toCharArray();
  302.         values[0] = Character.toUpperCase(firstChar);
  303.         return new String(values);
  304.     }
  305.  
  306. }

4.编写controller

  1. package com.lzl.controller;
  2.  
  3. import com.lzl.service.OnlinePreviewService;
  4. import org.springframework.beans.factory.annotation.Autowired;
  5. import org.springframework.web.bind.annotation.GetMapping;
  6. import org.springframework.web.bind.annotation.RequestParam;
  7. import org.springframework.web.bind.annotation.RestController;
  8.  
  9. import javax.servlet.http.HttpServletResponse;
  10.  
  11. @RestController
  12. public class OnlinePreviewController {
  13.  
  14.     @Autowired
  15.     private OnlinePreviewService onlinePreviewService;
  16.  
  17.     @GetMapping("/onlinePreview")
  18.     public void onlinePreview(@RequestParam("url") String url, HttpServletResponse response) throws Exception{
  19.         onlinePreviewService.onlinePreview(url,response);
  20.     }
  21. }

5.编写serivce和service实现类

  1. package com.lzl.service;
  2.  
  3. import javax.servlet.http.HttpServletResponse;
  4.  
  5. public interface OnlinePreviewService {
  6.  
  7.     void onlinePreview(String url, HttpServletResponse response) throws Exception;
  8. }
  1. package com.lzl.service.impl;
  2.  
  3. import com.lzl.service.OnlinePreviewService;
  4. import com.lzl.util.FileConvertUtil;
  5. import com.lzl.util.SmartStringUtil;
  6. import org.springframework.stereotype.Service;
  7.  
  8. import javax.servlet.http.HttpServletResponse;
  9. import java.io.InputStream;
  10. import java.io.OutputStream;
  11.  
  12. @Service
  13. public class OnlinePreviewServiceImpl implements OnlinePreviewService {
  14.  
  15.     @Override
  16.     public void onlinePreview(String url, HttpServletResponse response) throws Exception {
  17.         //获取文件类型
  18.         String[] str = SmartStringUtil.split(url, "\\.");
  19.  
  20.         if (str.length == 0) {
  21.             throw new Exception("文件格式不正确");
  22.         }
  23.         String suffix = str[str.length - 1];
  24.         if (!suffix.equals("txt") && !suffix.equals("doc") && !suffix.equals("docx") && !suffix.equals("xls")
  25.                 && !suffix.equals("xlsx") && !suffix.equals("ppt") && !suffix.equals("pptx")) {
  26.             throw new Exception("文件格式不支持预览");
  27.         }
  28.         InputStream in = FileConvertUtil.convertLocaleFile(url, suffix);
  29.         OutputStream outputStream = response.getOutputStream();
  30.         //创建存放文件内容的数组
  31.         byte[] buff = new byte[1024];
  32.         //所读取的内容使用n来接收
  33.         int n;
  34.         //当没有读取完时,继续读取,循环
  35.         while ((n = in.read(buff)) != -1) {
  36.             //将字节数组的数据全部写入到输出流中
  37.             outputStream.write(buff, 0, n);
  38.         }
  39.         //强制将缓存区的数据进行输出
  40.         outputStream.flush();
  41.         //关流
  42.         outputStream.close();
  43.         in.close();
  44.     }
  45. }

三 测试

启动项目测试

报错

  1. java.lang.IllegalArgumentException: inputFormat is null
  2. 	at com.artofsolving.jodconverter.openoffice.converter.AbstractOpenOfficeDocumentConverter.ensureNotNull(AbstractOpenOfficeDocumentConverter.java:113) ~[jodconverter-2.2.1.jar:na]
  3. 	at com.artofsolving.jodconverter.openoffice.converter.AbstractOpenOfficeDocumentConverter.convert(AbstractOpenOfficeDocumentConverter.java:79) ~[jodconverter-2.2.1.jar:na]
  4. 	at com.lzl.util.FileConvertUtil.covertCommonByStream(FileConvertUtil.java:77) ~[classes/:na]
  5. 	at com.lzl.util.FileConvertUtil.convertLocaleFile(FileConvertUtil.java:38) ~[classes/:na]

原因是jodconverter 2.2.1 版本不支持docx、xlsx、pptx 转换成PDF格式异常

解决办法：

新建​​com.artofsolving.jodconverter​​​包重写​​BasicDocumentFormatRegistry​​类

  1. package com.artofsolving.jodconverter​​​;
  2.  
  3. import com.artofsolving.jodconverter.DocumentFormat;
  4. import com.artofsolving.jodconverter.DocumentFormatRegistry;
  5.  
  6. import java.util.ArrayList;
  7. import java.util.Iterator;
  8. import java.util.List;
  9.  
  10. /**
  11.  *
  12.  * @description: 重写 BasicDocumentFormatRegistry 文档格式
  13.  *
  14.  */
  15. public class BasicDocumentFormatRegistry implements DocumentFormatRegistry {
  16.  
  17.     private List/* <DocumentFormat> */ documentFormats = new ArrayList();
  18.  
  19.     public void addDocumentFormat(DocumentFormat documentFormat) {
  20.         documentFormats.add(documentFormat);
  21.     }
  22.  
  23.     protected List/* <DocumentFormat> */ getDocumentFormats() {
  24.         return documentFormats;
  25.     }
  26.  
  27.  
  28.     @Override
  29.     public DocumentFormat getFormatByFileExtension(String extension) {
  30.         if (extension == null) {
  31.             return null;
  32.         }
  33.  
  34.         //将文件名后缀统一转化
  35.         if (extension.indexOf("doc") >= 0) {
  36.             extension = "doc";
  37.         }
  38.         if (extension.indexOf("ppt") >= 0) {
  39.             extension = "ppt";
  40.         }
  41.         if (extension.indexOf("xls") >= 0) {
  42.             extension = "xls";
  43.         }
  44.         String lowerExtension = extension.toLowerCase();
  45.         for (Iterator it = documentFormats.iterator(); it.hasNext(); ) {
  46.             DocumentFormat format = (DocumentFormat) it.next();
  47.             if (format.getFileExtension().equals(lowerExtension)) {
  48.                 return format;
  49.             }
  50.         }
  51.         return null;
  52.     }
  53.  
  54.     @Override
  55.     public DocumentFormat getFormatByMimeType(String mimeType) {
  56.         for (Iterator it = documentFormats.iterator(); it.hasNext(); ) {
  57.             DocumentFormat format = (DocumentFormat) it.next();
  58.             if (format.getMimeType().equals(mimeType)) {
  59.                 return format;
  60.             }
  61.         }
  62.         return null;
  63.     }
  64. }

重新启动项目 测试：

本文内容由网友自发贡献，转载请注明出处：https://www.wpsshop.cn/w/小丑西瓜9/article/detail/392956
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号