I'm having trouble finding an answer to this - I'm writing some simple VBA with the goal that my colleagues can install it as an add in or custom tab. Coming from Python I would, of course, prefer to work with xlwings or pyxll, but as I understood it in order to call any python you would have to install xlwings on every computer?
The ideal scenario would be that I could develop excel add ins with xlwings or pyxll and export it as if it were a normal excel add in, so that my colleagues can install it easily. Unfortunately, I can't install all the required python modules on every target computer.
is this possible or just wishful thinking?
One possibility is to convert all the required python files (your scripts, xlwings files and python interpreter) into a standalone executable. The xlwings website gives an example where this has been done (fibonacci_standalone.zip). See also the deployment docs page.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With