![]() ![]() And after that ? Libreoffice Calc will never launch again.Īdvanced features : multi sheets, lastrow What we need have to run in a thread and LibreOffice hates threads. I tryied many many many times to run a such code as a macro in LibreOffice. Sheet.getCellByPosition( 0, 1).setString( str(()))įirst step is done, we have now a solution to fill some data has we need. Resolver = ( ".UnoUrlResolver", localContext )Ĭtx = resolver.resolve( "uno:socket,host=localhost,port=2002 urp StarOffice.ComponentContext" )ĭesktop = smgr.createInstanceWithContext( ".Desktop",ctx) It opens some APIs we will use with a python script ![]() $ libreoffice "-accept=socket,host=localhost,port=2002 urp " accept=socket,host=localhost,port=2002 urp īy launching LibreOffice from a command line (or edit desktop or menu entries) : You can run LibreOffice in listening mode (port 2002) with option : Libreoffice APIsįirst question is : how to fill some cells directly by an API exposed by LibreOffice ? I changed the source protocol my a MQTT Client and the tool to libreoffice due to API limitations from Google spreadsheet. ![]() That's exactly why I modified the first version for my trainees. Do they really need such advanced software ? Most of time : noway ! ![]() Sometimes, big platforms are developped and deployed only for tests or prototypes. Building dashboards, alerting or other specific usage note provided by those products need some development. They have some essential elements such as a MQTT broker or a timeseries DB. Some tools exists, from big cloud providers such as AWS IOT, Google IOT, OVH Timeseries etc. I receive many requests about building IOT platforms. Two years later, I discovered that was a good idea not only for educational purposes. Two years ago, I made a special project for trainees with a mobile web page and Google Spreadsheet as a database/dashboard tool. Selfmade IOT Timeseries platform with LibreOffice ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |