JavaScriptDude/Libreoffice_Python_scripting.md

## Libreoffice_Python_scripting.md

      
    Raw
  

              Libreoffice_Python_scripting.md
            
          
    Installation

Linux package

sudo apt-get install python3-uno

Add python3 dist-packages to PYTHONPATH:

% dpkg-query -L python3-uno | grep dist
Add Dist Packages to PYTHONPATH in ~/.bashrc

Change this path as required
% export PYTHONPATH=/usr/lib/python3/dist-packages
Install pyoo:

% python3 -m pip install pyoo
Using pyoo

Start python uno bridge

Note: all libreoffice executables must be shut down first
This will start a headless window that will be used as a bridge for python script to access. This process must be left alive for pyoo to work
# soffice --accept="pipe,name=oo_pyuno;urp;" --norestore --nologo --nodefault # --headless
Access from Python - Spreadsheet example

#!/usr/local/bin/python3
import pyoo
desktop = pyoo.Desktop(pipe='oo_pyuno')
wkbk = desktop.open_spreadsheet("<xls_file_name>")
sheet = wkbk.sheets['<sheet_name>']
# Write value 'foo' to cell E5 on <sheet_name>
sheet[4,4].value='foo'
wkbk.save()
wkbk.close()

See: https://pypi.org/project/pyoo/ for more details