Ask Your Question

Automate updating of external Data through console

asked 2018-07-05 09:18:52 +0200

sisihagen gravatar image


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 Silvio

edit retag flag offensive close merge delete


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

Mike Kaganski gravatar imageMike Kaganski ( 2018-07-05 09:27:12 +0200 )edit

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?

Lupp gravatar imageLupp ( 2018-07-05 10:09:04 +0200 )edit

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.

sisihagen gravatar imagesisihagen ( 2018-07-05 12:37:17 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-07-05 17:22:09 +0200

erAck gravatar image

IMHO there's no such possibility from the command line. You could probably write an UNO extension (or maybe someone did already? try and 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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-05 09:18:52 +0200

Seen: 44 times

Last updated: Jul 05 '18