How to embed your Python code in Excel with xlwings PRO (no more external source code file needed)

xlwings PRO allows you to store the Python code directly in your Excel file. This makes deployment a lot easier and feels like dealing with VBA. You can protect your source code by using hidden or very hidden sheets.

[ACaffeineAddict]

One of the biggest attractions of VBA (for me, at least) is the VBE. Press Alt-11, insert module, write a function. It has intellisense, an object model I have memorized, instant type checking. Press F5. Is it possible to use xlwings to code python using Excel's VBE with all the niceties that we get from VBA? If not, is it on the roadmap?

[thefamousdjx]

1:31 RunPython still looks quite slow, I know there's a delay before python code runs since the interpreter has to start up but I had thought Pro will be faster

[buckyafitch]

Hello, This is very interesting. I am a freelancer and I have been coding in VBA for several years and have been learning Python.

My questions is, is there a way to run python script, without my client needing to install additional add-ins? VBA is very seamless in that sense, clients do not have to do anything at their end just click buttons and be done?

[timlambe]

Is this or something simular somehow possible without having xlwings pro? Its not affordable for a private person!