基于OpenOffice转换文档为PDF（PaperSize的使用，包含全部代码）

柔光的暖阳◎ 2022-12-28 14:20 363阅读 0赞

## 需求 ##

将 office 文档，转换为 pdf 文档。本文是基于一个列很多的Excel，不折行输出 pdf。

## 方案 ##

使用 jodconverter 基于 ApacheOpenOffice、LibreOffice 进行转换，本文当前使用 jodconverter 版本为 4.3.0 框架使用 springboot。  
本文示例主要说明，如何设置 PaperSize 来输出指定页面尺寸大小的 pdf。

> 至于你是用 OpenOffice 库还是用 LibreOffice 库，需要结合实际情况。比如你想将 word 文档进行转换为 pdf，转换后的样子一般就是你打开查看的样子，有时候会存在部分样式不兼容问题（比如某个 word 文档，OpenOffice 打开查看没有背景图，而 LibreOffice 打开可以正常显示），结合实际情况自行测试然后选择。

## 源码 ##

入门比较简单，这里就没有什么需要赘述的话，直接贴上工程所有代码，如下：  
![代码结构][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70]  
**pom.xml**

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.4.1</version>
            <relativePath/> 
        </parent>
        <groupId>com.example.office2pdf</groupId>
        <artifactId>office2pdf</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>office2pdf</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
            <jodconverter.version>4.3.0</jodconverter.version>
        </properties>
    
        <dependencies>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>commons-io</groupId>
                <artifactId>commons-io</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-lang3</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <optional>true</optional>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            <dependency>
                <groupId>org.jodconverter</groupId>
                <artifactId>jodconverter-spring-boot-starter</artifactId>
                <version>${jodconverter.version}</version>
            </dependency>
            <dependency>
                <groupId>org.jodconverter</groupId>
                <artifactId>jodconverter-core</artifactId>
                <version>${jodconverter.version}</version>
            </dependency>
            <dependency>
                <groupId>org.jodconverter</groupId>
                <artifactId>jodconverter-local</artifactId>
                <version>${jodconverter.version}</version>
            </dependency>
    
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <configuration>
                        <excludes>
                            <exclude>
                                <groupId>org.projectlombok</groupId>
                                <artifactId>lombok</artifactId>
                            </exclude>
                        </excludes>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    
    </project>

**application.properties**

jodconverter.local.enabled=true
    jodconverter.local.port-numbers=2002
    #jodconverter.local.office-home=D:\\Program Files\\LibreOffice
    jodconverter.local.office-home=d:\\Program Files (x86)\\OpenOffice 4

> 配置 OpenOffice 和 LibreOffice 都可以，不太恰当的比喻来说他俩是一个娘的

**Office2pdfApplication.java**

package com.example.office2pdf.office2pdf;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class Office2pdfApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(Office2pdfApplication.class, args);
        }
    
    }

**JodConvertService.java**

package com.example.office2pdf.office2pdf.service;
    
    import java.io.File;
    
    /**
     * 文档转换
     * 例如：word、excel 转换为 pdf
     *
     * @author shanhy
     * @date 2020/12/17 11:27
     */
    public interface JodConvertService {
    
        boolean convert(File sourceFile, File targetFile);
    
    }

**JodConverterRefreshFilter.java**

package com.example.office2pdf.office2pdf.service;
    
    import com.sun.star.awt.Size;
    import com.sun.star.beans.PropertyValue;
    import com.sun.star.lang.IllegalArgumentException;
    import com.sun.star.lang.XComponent;
    import com.sun.star.uno.UnoRuntime;
    import com.sun.star.view.PaperFormat;
    import com.sun.star.view.XPrintable;
    import lombok.extern.slf4j.Slf4j;
    import org.jodconverter.core.office.OfficeContext;
    import org.jodconverter.local.filter.FilterChain;
    import org.jodconverter.local.filter.RefreshFilter;
    
    /**
     * 重写 RefreshFilter
     *
     * @author shanhy
     * @date 2020/12/17 10:05
     */
    @Slf4j
    public class JodConverterRefreshFilter extends RefreshFilter {
    
        public final static Size A6, A5, A4, A3, A2, A1, A0;
        public final static Size B6, B5, B4, B3, B2, B1, B0;
    
        static {
            A6 = new Size(10500, 14800);
            A5 = new Size(14800, 21000);
            A4 = new Size(21000, 29700);
            A3 = new Size(29700, 42000);
            A2 = new Size(42000, 59400);
            A1 = new Size(59400, 84100);
            A0 = new Size(84100, 118900);
    
            B6 = new Size(12500, 17600);
            B5 = new Size(17600, 25000);
            B4 = new Size(25000, 35300);
            B3 = new Size(35300, 50000);
            B2 = new Size(50000, 70700);
            B1 = new Size(70700, 100000);
            B0 = new Size(100000, 141400);
        }
    
        /**
         * Creates a new refresh filter.
         */
        public JodConverterRefreshFilter() {
            this(false);
        }
    
        /**
         * Creates a new refresh filter that will call or not the next filter in the chain according to
         * the specified argument.
         *
         * @param lastFilter If {@code true}, then the filter won't call the next filter in the chain. If
         * {@code false}, the next filter in the chain, if any, will be applied.
         */
        public JodConverterRefreshFilter(final boolean lastFilter) {
            super(lastFilter);
        }
    
        @Override
        public void doFilter(
                final OfficeContext context,
                final XComponent document,
                final FilterChain chain)
                throws Exception {
    
            setPaperInfo(document, new Size(67000, 20000));
    
            super.doFilter(context, document, chain);
        }
    
        /**
         * 设置纸张信息
         * 请注意！！！PaperOrientation 和 PaperSize 不可以同时配置，否则有一个无效！
         * <p>
         * The default paper format and orientation is A4 and portrait.
         *
         * @param paperSize
         */
        private void setPaperInfo(final XComponent document, final Size paperSize) throws IllegalArgumentException {
    
            XPrintable xPrintable = UnoRuntime.queryInterface(XPrintable.class, document);
            PropertyValue[] printerDesc = new PropertyValue[2];
    
            // Paper Orientation（纵向横向）
    //        printerDesc[0] = new PropertyValue();
    //        printerDesc[0].Name = "PaperOrientation";
    //        printerDesc[0].Value = PaperOrientation.LANDSCAPE;
    
            // Paper Format
            printerDesc[0] = new PropertyValue();
            printerDesc[0].Name = "PaperFormat";
            printerDesc[0].Value = PaperFormat.USER;
    
            // Paper Size
            printerDesc[1] = new PropertyValue();
            printerDesc[1].Name = "PaperSize";
            printerDesc[1].Value = paperSize;
    
            xPrintable.setPrinter(printerDesc);
    
        }
    }

**JodConvertServiceImpl.java**

package com.example.office2pdf.office2pdf.service.impl;
    
    import com.example.office2pdf.office2pdf.service.JodConvertService;
    import lombok.extern.slf4j.Slf4j;
    import org.jodconverter.core.DocumentConverter;
    import org.jodconverter.core.office.OfficeException;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.io.File;
    
    /**
     * Office转换为PDF
     *
     * @author shanhy
     * @date 2020/12/16 16:58
     */
    @Service
    @Slf4j
    public class JodConvertServiceImpl implements JodConvertService {
    
        /**
         * 转换器注入
         */
        @Autowired
        private DocumentConverter converter;
    
        @Override
        public boolean convert(File sourceFile, File targetFile) {
            try {
                converter.convert(sourceFile).to(targetFile).execute();
                return true;
            } catch (OfficeException e) {
                log.error("转换office文档失败", e);
            }
            return false;
        }
    
    }

**TestController.java**

package com.example.office2pdf.office2pdf.controller;
    
    import com.example.office2pdf.office2pdf.service.JodConvertService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.io.File;
    
    /**
     * @author shanhy
     * @date 2020/12/16 17:14
     */
    @RestController
    @RequestMapping("/test")
    public class TestController {
    
        @Autowired
        private JodConvertService officeConvertService;
    
        @GetMapping("/test1")
        public boolean test1(String sourceFileName, String targetFileName) {
            File sourceFile = new File("D:\\Desktop\\officeconvert\\".concat(sourceFileName));
            File targetFile = new File("D:\\Desktop\\officeconvert\\".concat(targetFileName));
            return officeConvertService.convert(sourceFile, targetFile);
        }
    }

**JodConverterConfiguration.java**

package com.example.office2pdf.office2pdf.config;
    
    import com.example.office2pdf.office2pdf.service.JodConverterRefreshFilter;
    import org.jodconverter.core.DocumentConverter;
    import org.jodconverter.core.document.DocumentFormatRegistry;
    import org.jodconverter.core.office.OfficeManager;
    import org.jodconverter.local.LocalConverter;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    /**
     * @author shanhy
     * @date 2020/12/17 9:52
     */
    @Configuration
    public class JodConverterConfiguration {
    
        @Bean
        DocumentConverter localDocumentConverter(OfficeManager localOfficeManager, DocumentFormatRegistry documentFormatRegistry) {
            return LocalConverter.builder().filterChain(
    //                new PageMarginsFilter(0,0,0,0), // 对word有用，多excel似乎没什么用
                    new JodConverterRefreshFilter(true)
            ).officeManager(localOfficeManager).formatRegistry(documentFormatRegistry).build();
        }
    
    }

最后，准备一个很多列的Excel，进行测试。Excel 很简单，下面给出截图，请自行构造。

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70 1]  
下面是上面 Excel 转换输出后的 pdf 文件截图。

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70 3]

测试URL：http://localhost:8080/test/test1?sourceFileName=test3.xlsx&targetFileName=test3.pdf

官方源码地址：https://github.com/sbraconnier/jodconverter

[下一篇：《如何让很多列的 Excel 不折行输出到PDF中》][Excel _PDF]

--------------------

（END）

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70]: /images/20221120/eb212a4ebafe4e2da7da00aaea3e8487.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70 1]: /images/20221120/651c3611972f48cf825615cc9592d2f7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70 2]: /images/20221120/8cf7b558ef774a07aa3e38b2ed8736a3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NhdG9vcA_size_16_color_FFFFFF_t_70 3]: /images/20221120/93830f5d6c8c49ff826e8d3d57b59f8c.png
[Excel _PDF]: https://shanhy.blog.csdn.net/article/details/111387335