There's a Python wrapper for the Java API. Documentation is scarce. Also Libreoffice only supports any of the nice and new Excel functionality .... since last month: https://bugs.documentfoundation.org/show_bug.cgi?id=126573