So could you do UDFs with this?
No but have a look at https://github.com/ericremoreynolds/excelpython for UDFs.
Use Python in Excel without add-ins
11–20 of 73 posts
Re: Use Python in Excel without add-ins
#12Kind of a serious difference... This is using Excel in Python. Python is not running inside Excel with this.
Re: Use Python in Excel without add-ins
#13This is fantastic - I am going to start testing it now. I write a fair amount of VB macros, and would much prefer to be able to use Python. And, if they could create a plugin that allowed Libre Office to do the same, they could solve one of the last remaining major interoperability issues with LO and Excel: the inability to run VB macros in LO. That would be huge.
In LO you cannot define format strings that automagically scale the number, e.g. "d = "0"mm"%%% to use meters for further calculations yet display in mm.
Re: Use Python in Excel without add-ins
#14I use it since today, and I'm very impressed. I work for a financial startups, with old fashioned non-tech guys who works only on excel. Xlwings sove me from VBA programmation for my algorithms ...
Re: Use Python in Excel without add-ins
#15Kind of a serious difference... This is using Excel in Python. Python is not running inside Excel with this.
True, but you can trigger Python code from Excel using this so it seems reasonable enough.
Re: Use Python in Excel without add-ins
#16So do you need excel to be installed to use this? Currently I use xlwt and read the files with google docs.
Re: Use Python in Excel without add-ins
#17So this talks via IPC to Excel? How does it perform when working with huge data sets? Is the copying back and forth between the two processes a bigger bottleneck than the Python interpreter itself?
Re: Use Python in Excel without add-ins
#18So could you do UDFs with this?
No but have a look at https://github.com/ericremoreynolds/excelpython for UDFs.
Cool. The problem with all these big "VBA replacements" (and don't get me wrong, I've done both VBA and VSTO and the latter is more pleasant to work with) is that they never seem to provide replacements for UDFs, which is probably the #1 reason you'd want to use VBA in the first place.
Re: Use Python in Excel without add-ins
#19I know this doesn't support Linux and LibreOffice, but could it? Is there a technical way that would allow Python to sit alongside LibreOffice?
Re: Use Python in Excel without add-ins
#20I am guessing DataNitro isn't happy about this
Ha.