I have a script that uses Excel.
It’s worked well for years.
However, my company has decided to use LibreOffice instead.
Is there anyway to rewrite a script for LibreOffice?
thanx
iMac
Yosemite 10.10.4
LibreOffice 5.0.4
I have a script that uses Excel.
It’s worked well for years.
However, my company has decided to use LibreOffice instead.
Is there anyway to rewrite a script for LibreOffice?
thanx
iMac
Yosemite 10.10.4
LibreOffice 5.0.4
In short: No
As in OpenOffice you can make use of the uno service and use programming languages like C++, Python, Java or BASIC to automate OfficeLibre. However, there is no AppleEvent interface for the application bundle and therefore there is no way you can script OfficeLibre using AppleScript. The beauty of all the different supported programming languages is that you can send and receive AppleEvents (commands in AppleScript) using C++ or Python and therefore you can still make indirectly use of the same commands as in AppleScript like getting Finder selections for instance.
If you want to start with this and haven’t used with AppleScript’s underlying AppleEvent system it can be quite difficult at first. You can also use NSAppleScript in Python when you load the PyObjC module which makes it a lot easier, something I use for my own linter in SublimeText.