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

Apache Openoffice（2）：Java实现word、excel、ppt、txt等办公文件在线预览功能_java实现在线预览excel并保存

作者：繁依Fanyi0 | 2024-07-14 17:30:29

赞

踩

java实现在线预览excel并保存

项目文件结构如下：

 

1、项目的pom文件中引入依赖

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.7.5</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  11.     <groupId>com.example</groupId>
  12.     <artifactId>demo</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>demo</name>
  15.     <description>Demo project for Spring Boot</description>
  16.     <properties>
  17.         <java.version>1.8</java.version>
  18.     </properties>
  19.     <dependencies>
  20.         <dependency>
  21.             <groupId>org.springframework.boot</groupId>
  22.             <artifactId>spring-boot-starter-web</artifactId>
  23.         </dependency>
  24.  
  25.         <dependency>
  26.             <groupId>org.springframework.boot</groupId>
  27.             <artifactId>spring-boot-starter-test</artifactId>
  28.             <scope>test</scope>
  29.         </dependency>
  30.  
  31.         <!-- office to pdf need install something start -->
  32.         <dependency>
  33.             <groupId>com.artofsolving</groupId>
  34.             <artifactId>jodconverter</artifactId>
  35.             <version>2.2.1</version>
  36.         </dependency>
  37.         <dependency>
  38.             <groupId>org.openoffice</groupId>
  39.             <artifactId>ridl</artifactId>
  40.             <version>4.1.2</version>
  41.         </dependency>
  42.         <dependency>
  43.             <groupId>org.openoffice</groupId>
  44.             <artifactId>juh</artifactId>
  45.             <version>4.1.2</version>
  46.         </dependency>
  47.         <dependency>
  48.             <groupId>org.openoffice</groupId>
  49.             <artifactId>jurt</artifactId>
  50.             <version>4.1.2</version>
  51.         </dependency>
  52.         <dependency>
  53.             <groupId>org.openoffice</groupId>
  54.             <artifactId>unoil</artifactId>
  55.             <version>4.1.2</version>
  56.         </dependency>
  57.         <!-- office to pdf need install something end-->
  58.  
  59.         <!-- commons-io start -->
  60.         <dependency>
  61.             <groupId>commons-io</groupId>
  62.             <artifactId>commons-io</artifactId>
  63.             <version>2.8.0</version>
  64.         </dependency>
  65.         <!-- commons-io end -->
  66.  
  67.         <!-- jackson start -->
  68.         <dependency>
  69.             <groupId>com.fasterxml.jackson.core</groupId>
  70.             <artifactId>jackson-databind</artifactId>
  71.             <version>2.12.1</version>
  72.         </dependency>
  73.  
  74.         <dependency>
  75.             <groupId>com.fasterxml.jackson.core</groupId>
  76.             <artifactId>jackson-core</artifactId>
  77.             <version>2.12.1</version>
  78.         </dependency>
  79.  
  80.         <dependency>
  81.             <groupId>com.fasterxml.jackson.core</groupId>
  82.             <artifactId>jackson-annotations</artifactId>
  83.             <version>2.12.1</version>
  84.         </dependency>
  85.         <!-- jackson end -->
  86.  
  87.         <!-- log start -->
  88.         <dependency>
  89.             <groupId>org.slf4j</groupId>
  90.             <artifactId>slf4j-api</artifactId>
  91.             <version>1.7.25</version>
  92.         </dependency>
  93.  
  94.         <dependency>
  95.             <groupId>ch.qos.logback</groupId>
  96.             <artifactId>logback-core</artifactId>
  97.             <version>1.2.3</version>
  98.         </dependency>
  99.         <dependency>
  100.             <groupId>ch.qos.logback</groupId>
  101.             <artifactId>logback-classic</artifactId>
  102.             <version>1.2.3</version>
  103.         </dependency>
  104.         <!-- log end -->
  105.  
  106.         <dependency>
  107.             <groupId>org.apache.commons</groupId>
  108.             <artifactId>commons-lang3</artifactId>
  109.             <version>3.10</version>
  110.         </dependency>
  111.     </dependencies>
  112.  
  113.     <build>
  114.         <plugins>
  115.             <plugin>
  116.                 <groupId>org.springframework.boot</groupId>
  117.                 <artifactId>spring-boot-maven-plugin</artifactId>
  118.             </plugin>
  119.         </plugins>
  120.     </build>
  121.  
  122. </project>

2、SmartStringUtil字符串操作工具类

  1. package com.example.demo.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.  
  11. public class SmartStringUtil extends StringUtils {
  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.

3、将word、excel、ppt转换为pdf流的工具类代码

  1. package com.example.demo.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. public class FileConvertUtil {
  16.     /** 默认转换后文件后缀 */
  17.     private static final String DEFAULT_SUFFIX = "pdf";
  18.     /** openoffice_port */
  19.     private static final Integer OPENOFFICE_PORT = 8100;
  20.  
  21.     private static final String CONNECT_IP = "192.168.222.131";
  22.  
  23.     /**
  24.      * 方法描述 office文档转换为PDF(处理本地文件)
  25.      *
  26.      * @param sourcePath 源文件路径
  27.      * @param suffix     源文件后缀
  28.      * @return InputStream 转换后文件输入流
  29.      * @author tarzan
  30.      */
  31.     public static InputStream convertLocaleFile(String sourcePath, String suffix) throws Exception {
  32.         File inputFile = new File(sourcePath);
  33.         InputStream inputStream = new FileInputStream(inputFile);
  34.         return covertCommonByStream(inputStream, suffix);
  35.     }
  36.  
  37.     /**
  38.      * 方法描述  office文档转换为PDF(处理网络文件)
  39.      *
  40.      * @param netFileUrl 网络文件路径
  41.      * @param suffix     文件后缀
  42.      * @return InputStream 转换后文件输入流
  43.      * @author tarzan
  44.      */
  45.     public static InputStream convertNetFile(String netFileUrl, String suffix) throws Exception {
  46.         // 创建URL
  47.         URL url = new URL(netFileUrl);
  48.         // 试图连接并取得返回状态码
  49.         URLConnection urlconn = url.openConnection();
  50.         urlconn.connect();
  51.         HttpURLConnection httpconn = (HttpURLConnection) urlconn;
  52.         int httpResult = httpconn.getResponseCode();
  53.         if (httpResult == HttpURLConnection.HTTP_OK) {
  54.             InputStream inputStream = urlconn.getInputStream();
  55.             return covertCommonByStream(inputStream, suffix);
  56.         }
  57.         return null;
  58.     }
  59.  
  60.     /**
  61.      * 方法描述  将文件以流的形式转换
  62.      *
  63.      * @param inputStream 源文件输入流
  64.      * @param suffix      源文件后缀
  65.      * @return InputStream 转换后文件输入流
  66.      * @author tarzan
  67.      */
  68.     public static InputStream covertCommonByStream(InputStream inputStream, String suffix) throws Exception {
  69.         ByteArrayOutputStream out = new ByteArrayOutputStream();
  70.         OpenOfficeConnection connection = new SocketOpenOfficeConnection(CONNECT_IP,OPENOFFICE_PORT);
  71.         connection.connect();
  72.         DocumentConverter converter = new StreamOpenOfficeDocumentConverter(connection);
  73.         DefaultDocumentFormatRegistry formatReg = new DefaultDocumentFormatRegistry();
  74.         DocumentFormat targetFormat = formatReg.getFormatByFileExtension(DEFAULT_SUFFIX);
  75.         DocumentFormat sourceFormat = formatReg.getFormatByFileExtension(suffix);
  76.         converter.convert(inputStream, sourceFormat, out, targetFormat);
  77.         connection.disconnect();
  78.         return outputStreamConvertInputStream(out);
  79.     }
  80.  
  81.     /**
  82.      * 方法描述 outputStream转inputStream
  83.      *
  84.      * @author tarzan
  85.      */
  86.     public static ByteArrayInputStream outputStreamConvertInputStream(final OutputStream out) throws Exception {
  87.         ByteArrayOutputStream baos=(ByteArrayOutputStream) out;
  88.         return new ByteArrayInputStream(baos.toByteArray());
  89.     }
  90.  
  91.  
  92.  
  93.     public static void main(String[] args) throws IOException {
  94.         //convertNetFile("http://172.16.10.21/files/home/upload/department/base/201912090541573c6abdf2394d4ae3b7049dcee456d4f7.doc", ".pdf");
  95.         //convert("c:/Users/admin/Desktop/2.pdf", "c:/Users/admin/Desktop/3.pdf");
  96.     }
  97. }

4、iservice层在线预览方法代码

  1. package com.example.demo.service;
  2.  
  3. import javax.servlet.http.HttpServletResponse;
  4.  
  5. public interface onlineService {
  6.     void onlinePreview(String url, HttpServletResponse response) throws Exception;
  7. }
  8.

5、service层在线预览方法代码

  1. package com.example.demo.service.impl;
  2.  
  3. import com.example.demo.service.onlineService;
  4. import com.example.demo.util.FileConvertUtil;
  5. import com.example.demo.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 onlineServiceImpl implements onlineService {
  14.  
  15.     /**
  16.      * @Description:系统文件在线预览接口
  17.      * @Author: tarzan
  18.      */
  19.     @Override
  20.     public void onlinePreview(String url, HttpServletResponse response) throws Exception {
  21.         //获取文件类型
  22.         String[] str = SmartStringUtil.split(url,"\\.");
  23.  
  24.         if(str.length==0){
  25.             throw new Exception("文件格式不正确");
  26.         }
  27.         String suffix = str[str.length-1];
  28.         if(!suffix.equals("txt") && !suffix.equals("doc") && !suffix.equals("docx") && !suffix.equals("xls")
  29.                 && !suffix.equals("xlsx") && !suffix.equals("ppt") && !suffix.equals("pptx")){
  30.             throw new Exception("文件格式不支持预览");
  31.         }
  32.         InputStream in= FileConvertUtil.convertNetFile(url,suffix);
  33.         OutputStream outputStream = response.getOutputStream();
  34.         //创建存放文件内容的数组
  35.         byte[] buff =new byte[1024];
  36.         //所读取的内容使用n来接收
  37.         int n;
  38.         //当没有读取完时,继续读取,循环
  39.         while((n=in.read(buff))!=-1){
  40.             //将字节数组的数据全部写入到输出流中
  41.             outputStream.write(buff,0,n);
  42.         }
  43.         //强制将缓存区的数据进行输出
  44.         outputStream.flush();
  45.         //关流
  46.         outputStream.close();
  47.         in.close();
  48.     }
  49. }

6、controler层代码

  1. package com.example.demo.controller;
  2.  
  3. import com.example.demo.service.onlineService;
  4. //import io.swagger.annotations.ApiOperation;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.web.bind.annotation.*;
  7.  
  8. import javax.servlet.http.HttpServletResponse;
  9.  
  10. @RestController
  11. public class onlineController {
  12.     @Autowired
  13.     onlineService onlineService1;
  14.  
  15. //    @ApiOperation(value = "系统文件在线预览接口 by tarzan")
  16.     @PostMapping("/api/file/onlinePreview")
  17.     public void onlinePreview(@RequestParam("url") String url, HttpServletResponse response) throws Exception{
  18.         onlineService1.onlinePreview(url,response);
  19.     }
  20.  
  21.  
  22. }

7、postman测试

传入文件的URL

 弹出文件下载框，如果实在浏览器则会弹出页面

 

声明：本文内容由网友自发贡献，转载请注明出处：【wpsshop】
推荐阅读
相关标签

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

  

闽ICP备14008679号