3 ms·
Not a programmer, but I see it can use COM objects : https://luart.org/doc/sys/COM-constructor.html https://luart.org/doc/sys/COM-constructor.html does that m
by bionsystem 2y ago
Not a programmer, but I see it can use COM objects :
https://luart.org/doc/sys/COM-constructor.html https://luart.org/doc/sys/COM-constructor.html
does that mean we can use it to manipulate Office files just as in VB or PowerShell ?
- jodrellblank 2y agoA COM client will let you control Office desktop applications, and use those to open and edit Office files. You need them installed first. (Contrast with Doug Finke’s Import-Excel module for PowerShell which can work with Excel files without Excel installed, and Przemysław Kłys‘s PSWriteWord module that can write Word files without Word. They can’t do as much as full Excel and Word can).
- bionsystem 2y agoThanks this is very clear. I use COM objects through PowerShell too, not the Import-Excel module, because I cannot install anything (except Office) on my client's work machine. But I can copy binaries so working with Lua might relieve my headaches from working with PowerShell :)
- jodrellblank 2y agoFrom the PowerShell Github releases page[1] you can expand 'assets' and 'show more assets' and find a ZIP distribution which doesn't need installing, unzip it. e.g. PowerShell-7.4.2-win-x64.zip . Then from PowerShell 7 somewhere, run Save-Module ImportExcel -Path C:\Whatever\ and copy that module folder along with the PowerShell folder to the remote machine, and you can import modules from a full path: Import-Module C:\Whatever\ImportExcel and do a no-install copy-paste deployment of powershell 7 and modules. (I'm not saying you should do this instead of using Lua, just that you can). [1] https://github.com/PowerShell/PowerShell/releases https://github.com/PowerShell/PowerShell/releases
- bionsystem 2y agoNice, thanks. But I have other limitations as well (Powershell 5 only and scripts must be signed, which I believe includes external modules). Don't ask me why I can run a random binary instead, I don't know and I don't want to know.
- _samt_ 2y agoI'm the main author of LuaRT. Yes LuaRT can automate Office apps through COM
- bionsystem 2y agoGreat job, thanks for your work !
- _samt_ 2y agoThank you :)
- walterbell 2y agoCan COM automation work between two networked Windows desktops? Edit: I guess that would be DCOM, https://en.wikipedia.org/wiki/Distributed_Component_Object_Model https://en.wikipedia.org/wiki/Distributed_Component_Object_M...
- _samt_ 2y agoI don't have tested this