This page is for administrators who want to enable PhixFlow to convert Excel files to PDFs when exporting from analysis models.

Overview

When creating analysis models, data modellers can configure a file exporter to export data from PhixFlow in several different formats, such as CSV or Excel. For Excel files, there is also an option to convert the file into a PDF document:

• Convert To PDF

For more information about this option, see File Exporter.

Configuration

PhixFlow uses LibreOffice libraries to convert an Excel file into a PDF.

To enable PDF conversion conversion in PhixFlow:

1. Install the latest minor version of LibreOffice Version 7.2 on the PhixFlow server using the default settings. LibreOffice is available from https://www.libreoffice.org/download/download

2. Edit the file $TOMCAT/conf/catalina.properties:

Find the line which starts common.loader= and add the path to the LibreOffice Program folder at the end of that line so that the line looks something like:

common.loader="${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar","C:/Program Files/LibreOffice/program"