Make LibreOffice Calc Programmable using Python

Session Details

In a spreadsheet with more than thousands of rows, using a macro for certain tasks is far more manageable rather than doing it manually by hand. There are many programming languages that can be used to create a macro in LibreOffice, one of which is Python. Universal Network Objects (UNO) is used to access LibreOffice using its Application Programming Interface (API). With the help of PyUNO--UNO bindings for the Python programming language, we can use LibreOffice's API from a Python code. This proposal focuses on a guide on how to write a Python macro for LibreOffice Calc, along with practical examples of some nice-to-have macros.