Hi! I am starting to look at Openoffice API but got somewhat confused in what I have to use. I have a set of .xlsx files sitting on my web-server that I need to run through a certain pipeline that would go to particular cells and put a content from my database in there.
I do not need to embed the whole aplication with its GUI, I need to do it from a command line with a set of scripts. The language can be either JavaScript (so I’ll do it in Node.js) or better it could by Python, so I’d write the whole DB connecting and editing in one script…
If you are planning to edit those files locally on the server, then you can try using Document Builder for that case. Please find more information about it here:
It also can be integrated with your application in Python:
Basically, as an integrator you can implement any logic for connecting to a database and fetching the data for further insertion. To actually insert the data you can utilize all Office API methods available for JS context:
On the other hand, you have Document Server as it is set in the category, if it is correct. With Document Server you can use Document Builder API (basically, a web version of Document Builder I’ve mentioned above with some caveats):
In this case, you will have to predefine all necessary actions in JS as a .docbuilder file (please find more information about it here) that will be sent to the Document Builder API to process the file modification. This version of Document Builder directly supports all JS functionality, so you may decide how to connect to a database with them by yourself. Also, all methods from Office API are supported directly without any additional context.