I’ve got a spreadsheet in Calc containing people’s details. What I need to do is write a Python program (I’ve got a good grasp of Python, and would prefer to do this in it rather than StarBasic) that can be fed the person’s ID number and it will return the person’s other details in the spreadsheet (doing this running LO headlessly).
So essentially, how from Python, can I lookup a value in a specific column in a Calc spreadsheet and return the associated details (perhaps only specific ones [based on column number?]) to the Python script to manipulate.
I’d prefer to use the python “uno” library directly, because from what I can see the various higher-level frontends don’t have as active development.
I don’t know if there’s any platform specifics, but I’m using LibreOffice 184.108.40.206 on Kubuntu 14.04.
Also, are there any good guides to writing python interfaces/macros to LO?
Thanks in advance.