OOO Development Tools Tutorial - lo python excel

OooDev Tools comes with great documentation and examples but I miss the python REPL for a quick look at what is happening. I put flywire.github.io/OooDev_Tute together as an alternative introduction using the REPL.

The tutorial is a conversion of Automate the Boring Stuff with Python by Al Sweigart, Chapter 13 Working With Excel Spreadsheets to LibreOffice and Python. That chapter uses openpyxl, and comparing the openpyxl approach of using properties for everything with the ooouno interfaces of the LibreOffice API can be fairly worthwhile to understand how it works too.

The intention is to type or copy/paste lines as required to learn as you go. The copy button has a nice little feature of dropping the prompts and output to allow it to be pasted into the REPL.

It’s been a moving target but it currently runs on OooDev Version 0.11.0 although not updated to the latest enhancements. Thanks to @vib for the input along the way. Any issues or feedback welcome.

1 Like