Automate updating of external Data through console


Is it possible to have documents that have external data ready to be accessed via the console?

I have so to the 30 files to retrieve the data externally and then processed into a single file further. An automated updata of the Calc documents would be very helpful.

Thanks for the info

Please clarify the use case. What exactly do you need to do?

Quoting @sisihagen: “…have external data ready to be accessed via the console?”
Do you want to get an “Update on shortcut” replacing/completing the “Update every … seconds” feature?
In what way and wherefrom do your 30-odd files (spreadsheet files?) retrieve the data?
Might you, please explicate the phrase “…have external data ready to be accessed via the console”?
Do you mean “…refresh their external on a console action (shortcut key)”?
Are the files needing a refresh open?

Now I open all files one time in day to update all the spreadsheet. The question is can I open the files over console, without question “Do you want update”. Best would be as cronjob. But I find nothing so I think this will not work.

IMHO there’s no such possibility from the command line. You could probably write an UNO extension (or maybe someone did already? try and Search extensions | Apache OpenOffice Extensions) and run soffice -env:UserInstallation=... --headless --accept=... for a listening server instance to have the extension talk to the instance and load/update/save the documents. Just a quick idea… See and Apache OpenOffice Developer's Guide - Apache OpenOffice Wiki