#Open socket to LibraOffice with delay to allow program to wait for connection Pd.set_option('display.max_columns', None)ĭf = pd.read_sql("SELECT * FROM GVWC.2020", cnx) #runs query Us, pw=validateLogin() #returns login infoĬnx = (user=us, password=pw ,host='localhost', database= 'GVWC') # connects to DB ValidateLogin #opens input box for username and password # 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')
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:
0 kommentar(er)
