# opens connection to mysql database GVWC Hopefully this will help anyone who like me is new to this environment. I have supplied copies of all my Py scripts. After that I was able to use Uno and other modules to interact with the Calc spreadsheet. The main stumbling block that was causing me problems, was not understanding that LibreOffice needed to be initiated prior to connecting through the socket. I have supplied links to information sources I used to complete this project. I'm a Newbie at all of this, so please excuse my coding, I'm still learning. InProps = PropertyValue( 'Hidden', 0, True, 0 ), # this is a tupleĭocument = desktop.loadComponentFromURL('private:factory/scalc', '_blank', 0, inProps )įilter = uno.createUnoStruct('.PropertyValue')Īfter a lot of research, I have figured out how to manipulate a Ubuntu LibreOffice Calc sheet using Python 3.7 and P圜harm and MySQL. PropertyValue = uno.getClass('.PropertyValue') create a new Calc document ( private:factory/scalc):.)ĭesktop = uno_smgr.createInstanceWithContext('.Desktop', uno_ctx ) instantiate Desktop (the root frame for all applications - Calc, Writer, Draw.if succeeded, uno context is all you need.Url = 'uno:socket,host=localhost,port=2002,tcpNoDelay=1 urp StarOffice.ComponentContext' Resolver = smgr_local.createInstanceWithContext('.UnoUrlResolver', local_ctx)

open another terminal and enter python3 interactive mode:.

usr/lib/libreoffice/program/soffice.bin -headless -invisible -nocrashreport -nodefault -nofirststartwizard -nologo -norestore -accept='socket,host=localhost,port=2002,tcpNoDelay=1 urp StarOffice.ComponentContext'

start libreoffice process with opened socket (more info here - page 117):.

Type 'help', 'copyright', 'credits' or 'license' for more information.

check if uno is accessible (in my case this is all I've done):.

Sudo apt install libreoffice -no-install-recommends I had the same problem and I solved it like this:

Python libreoffice calc