Openoffice转换excel为pdf格式问题处理

问题背景：

基于Openoffice转换excel为pdf时，在linux环境下，默认配置转换后的pdf样式不受控。

解决方案：

JodConverter在文件正式转化前暴露了filter接口，供用户对文档格式等内容进行操作。在此基于自定义filter修改excel页面样式。

默认项目基于springboot，已经实现pdf转换的相关基础功能。

1. 自定义JodConverter取代默认JodConverter，在其中引入自定义的新filter

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;

@Configuration
public class JodConverterConfiguration {

    @Bean
    DocumentConverter localDocumentConverter(OfficeManager localOfficeManager, DocumentFormatRegistry documentFormatRegistry) {
        return LocalConverter.builder().filterChain(
        				//引入处理页面格式filter
                        new PageStyleRefactorFilter())
                .officeManager(localOfficeManager).formatRegistry(documentFormatRegistry).build();
    }
}

2. 自定义filter内容：具体实现参考JodConverter原生fllter（PageMarginsFilter），页面格式相关参数参考OpenOfiice api。

OpenOffice原生api非常难用，JodConverter作了一定的封装，建议使用Jod中封装的方法

import com.sun.star.beans.XPropertySet;
import com.sun.star.container.XNameAccess;
import com.sun.star.container.XNameContainer;
import com.sun.star.lang.XComponent;
import com.sun.star.style.XStyle;
import com.sun.star.style.XStyleFamiliesSupplier;
import lombok.extern.slf4j.Slf4j;
import org.jodconverter.core.office.OfficeContext;
import org.jodconverter.local.filter.Filter;
import org.jodconverter.local.filter.FilterChain;
import org.jodconverter.local.office.utils.Calc;
import org.jodconverter.local.office.utils.Lo;


public class PageStyleRefactorFilter implements Filter {

    public PageStyleRefactorFilter() {
    }

    @Override
    public void doFilter(OfficeContext context, XComponent document, FilterChain chain) throws Exception {
    	//只处理excel相关格式，其它格式文件可自行定义
        if (Calc.isCalc(document)) {
        	//以下api调用路径请参考OpenOffice官方api
            // Get the StyleFamiliesSupplier interface of the document
            final XStyleFamiliesSupplier xSupplier = Lo.qi(XStyleFamiliesSupplier.class, document);
            // Use the StyleFamiliesSupplier interface to get the XNameAccess interface of the
            // actual style families
            final XNameAccess xFamilies = Lo.qi(XNameAccess.class, xSupplier.getStyleFamilies());

            // Access the 'PageStyles' Family
            final XNameContainer xFamily = Lo.qi(XNameContainer.class, xFamilies.getByName("PageStyles"));

            // Get the style of the current page from the PageStyles family
            for (String name : xFamily.getElementNames()) {
                final XStyle xStyle = Lo.qi(XStyle.class, xFamily.getByName(name));
                // Get the property set of the style
                final XPropertySet xStyleProps = Lo.qi(XPropertySet.class, xStyle);
                //所有列打印到同一页
                xStyleProps.setPropertyValue("ScaleToPagesX", (short) 1);
                //打印excel grid
                xStyleProps.setPropertyValue("PrintGrid", true);
                //更多参数请参考官方api:https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Printing_Spreadsheet_Documents
            }
        }
        // Invoke the next filter in the chain
        chain.doFilter(context, document);
    }
}