Python in LibreOffice (LibrePythonista Extension) | Hacker News Reader

Python in LibreOffice (LibrePythonista Extension)

extensions.libreoffice.org

34 pointsnogajun5 comments

This is an extension that embeds Python in LibreOffice Calc like Python in Excel. Once the extension is installed, pandas, matplotlib, numpy, etc. are also installed, allowing tables to be manipulated as pandas data frames.

The difference with Python in Excel is that it works with Python embedded in LibreOffice. It can be used without external access.

GitHub: Amourspirit/python_libre_pythonista_ext: https://github.com/Amourspirit/python_libre_pythonista_ext

Introducing Python in LibreOffice Calc - YouTube: https://www.youtube.com/watch?v=AQLuSNHhUY4

Does this allow external programs/servers to interact with a workbook (xlsx file)? Or is this just to run more complex calculations inside cell(s)?

There's UNO and there's also openpyxl to interact with workbooks from Python, but both solutions were a bit slow when testing it.

There's a lot of value in having existing workbooks which a lot of businesses already use, and extending them so they can be interacted with or queried from a server. For example to allow further access from a webapp without allowing changes to the entire workbook or hiding the full dataset.

The linked page doesn't seem to have anything to say why I should adopt this tool. I use jupyter in preference to a spreadsheet partly because it separates data from analysis and from visualisation.

Your point is really interesting, I've seen similar articles and I still can't figure out why and how spreadsheets could be replaced by Jupyter Notebooks. While they are awesome for data analysis and building code by section, to the best of my knowledge the sequential execution lacks the flexibility of the dynamic interdependence of spreadsheets, so having the possibility to call dynamically Python code seems awesome to me in the context with several interconnected variable as it allows quick, simple and dynamic modeling. Am I missing something?

It might be all about different ways of working. I find it's very easy to make errors like selecting the wrong range in spreadsheets so I'm willing to lose some nimbleness to protect me from my own carelessness.

Reply on news.ycombinator.com