41–50 of 73 posts
Not sure if I see an actual use case for this since we live in a world that has Pandas, but I'm impressed.
But couldn't you do this with win32com.client already?
In the past, I've used Python to automate Excel, Outlook, and some non-MS products like Catia.
Honestly, I don't see the advantage here. FOSS is nice, and OSX support is nice, but if you're interacting with MS products, FOSS is not a concern anyway, and it's probably running on Windows...
What would be really nice is if it supported multiple backends, so I could run the same Python code with Excel, Apple's Numbers, Google spreadsheet or Gnumeric, and have it work the same on all of them.
So could you do UDFs with this?
No but have a look at https://github.com/ericremoreynolds/excelpython for UDFs.
This 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.
Might be irrevelant but anyone know best source to learn VB macros?
You can probably learn everything you need from Googling for solutions to problems, but that book was great when I was committed to working with Excel and Access for a while. It covers a lot of things you're not going to think to search about.
To run a python function you do need to write one line of VBA code and you also need a vba file that comes with the package so although its not very much to add on the VBA side the title here seems a bit misleading.
http://pyxll.com/ already does all of this, better In particular it's in-process and does UDFs. Admittedly it isn't open-source but it is free for non-commercial use.
This 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.
Might be irrevelant but anyone know best source to learn VB macros?
http://www.cpearson.com/Excel/Topic.aspx
Old websites but in my case I dealt with Office <= 2003
So 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?
This 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.
Might be irrevelant but anyone know best source to learn VB macros?
Earlier quoted context omitted.
Might be irrevelant but anyone know best source to learn VB macros?
When I had to spend a large amount of intimate time with VBA I used to go to http://www.cpearson.com/Excel/Topic.aspx http://www.ozgrid.com/VBA/ Old websites but in my case I dealt with Office <= 2003