REM language of choice (Python is the base). REM This module is used to set up the master script provider for the supported What would be your advice as to the best way to structure the system, and the best way to pass the data? This initial item has about 15 data elements that need to be passed from the spreadsheet to Python, but I can forsee much more complex and elaborate reports in future. However the difficulty is the production of barcodes, qrcodes, and other art, latex is much more flexible in this respect. I had hoped that I could use LibreOffice's own built in PDF facilities to produce this output. Write a wrapper function for Python (is this possible?) Secondly I am concerned about portability, ie I would like to simply pass a file that can be installed easily on another machine (spreadsheet and subsystem), that just works (on a machine that has xelatex of course).

There is no need to return a value to the spreadsheet, just to produce the pdf report on disk (for now).įirstly there is a need to pass the data via Basic to the Python subsystem. What I need to do is connect the data from the spreadsheet to the subsystem.

This is done by reading tex templates into Python Templates, passing to them a data dictionary (that would be loaded with spreadsheet data), writing them as temp files to disk, and then compiling them with Latex. I have a LibreOffice spreadsheet that is largely based upon Basic macros, but have set up a Python/Latex subsystem that can produce formatted PDF reports by assembling various Latex templates, with such things as barcodes, qrcodes and other art/images. This question is seeking advice from the experts.

Libreoffice calc python