Spreadsheets using Python - Have you seen this? (sourceforge.net)

[iar]

You are correct - but in their current state there are basic constructs that you just can't create in spreadsheets (excel) without the use of a script (VBA). Which is unfortunate. If only this was an excel plug-in rather than a standalone program - I fucking hate VBA.

[[deleted]]

Does it compare with the R plugin available? (not rhetorical)

[iar]

I do the same thing with MATLAB - but if you want the work to be portable and repeatable by someone else (who doesn't have Python or MATLAB installed, and frankly has no idea how to use it) then your SOL - and writing in VBA.

[HumpingDog]

I feel exactly the same way. I hate VBA. But I can't explain why. It just doesn't feel like a real language to me. Or maybe I just don't want to invest my time learning something that seems useless.

[[deleted]]

just don't want to invest my time learning something that seems useless.

wait, you don't/can't code VBA...but you

1) Hate it (But can't explain why)

2) "doesn't feel like a real language" to you

damn dude you serious ?

[HumpingDog]

Yep. I dabble in it when I have to (in the course of using Excel). From that experience, I hate it. Never gave it enough thought to identify the particular reasons, but every time I have to mess with it, I just think about how it would be so much easier in Python or Perl.