Is there a Python API into Calc or not?

[wmdoug_epling]

After reading through a bunch of stuff, I am still not clear on this question. I am leaning towards: No, there is only Java, or C++. But there seems to be a lot of confusion in the public domain over this topic. You get plenty of hits for using Python in LibreOffice Calc, but all I want to do is write into the two-dimensional grid of a spreadsheet from an EXISTING Python application. So technically speaking, I want to use LibreOffice in Python, not the other way around. Incidentally, I do not use Windows.

[Wanderer]

I will start with a comment, or better a question:
Do you want to “use” LibreOffice, and write in an active grid, visible on the screen like an actual user? Or is all you need a possibility to save the data of your python program as a spreadsheet, especially an odc-file?

[Wanderer]

As you may see in this answer

How python-uno can manipulate libreoffice-calc with pipe?

it is possible to start LibreOffice so that you can communicate with the program/uno-API via a port. This (german) article use this for automated reports.

Libre Office automatisiert testen - Seite 2 von 7

and here you find an question on this ask-site:

UNO: choosing between running office instances

When I start office as soffice --calc --accept="socket,host=localhost,port=2002;urp;StarOffice.ServiceManager" I can then choose File → Open…, and open a document in a completely new window. The code I know and have found everywhere, which is: #!python import uno # run libreoffice as: # soffice --calc --accept="socket,host=localhost,port=2002;urp;StarOffice.ServiceManager" def connectToLo(): # get the uno component context from the PyUNO runtime localContext = uno.getComponentContex…

[wmdoug_epling]

Thank you. The references are helpful.