Congrats guys love this stuff have been using it for a couple of months. The people who work on the Excel team were really impressed when I demoed it to them. Best of luck!
Great job guys! I'd love to know bit more about the exact benefits of using Python and a few simple examples of how to use it... then again, I am just a casual excel user so I am likely not the right audience
Thanks! We have some basic examples up on our blog. A good one is blackjack in Excel [1] - it shows off some of the versatility of Python as compared to VBA, like the ability to run a script in the background and have it respond to user actions.
Please take my money if you port VBA on top of your Python runtime. And take even more money if said embedded Python runtime is available on Openoffice as well.
[1] http://news.ycombinator.com/item?id=4360454
BTW, I'm not so sure Python in the right choice for this integration.
Whitespace sensitivity is (arguably) a nice developer mind trick, however the target market for VBA are non-developers, who want to google for stuff, copy paste and get on with it. Which means, you cannot make assumptions about things like editors honoring whitespace, as well as the cognitive processes to rely on spacing etc.
This is why I strongly believe Python is the wrong language for this - but some language is definitely needed (Lua ? Javascript? Ruby?)
With VBA, you can't just copy-paste code from google - it's rare that you'll find something that does exactly what you want it to do on your specific spreadsheet. Readability, then, becomes important - and Python is easier to parse and edit for someone with basic programming skills than VBA is.
Nice work. Some piece of feedback: documentation is lacking any information on how to interact with VBA functionality/classes that you don't have your wrappers for. E.g. how do I work with creating/opening/interacting with other workbooks?
I remember being so excited about this product that I sent a msg to the IronSpread team thanking them for their work, even though I hadn't even used their product yet. (I'd never done that before for any product)
It's great to see this taking off (and I had no idea it was part of YC until now), and am looking forward to future updates!
I think this is so awesome, I spent a summer as a lowly intern for a bank once trying to write up an entire debt model in VBA (bad idea on so many fronts...), and I wanted to gouge my eyes out at the end. I would've given an arm and a leg to be able to write in Python, as I'm sure many others...so excited to see this happen!
29 comments
[ 3.0 ms ] story [ 76.5 ms ] thread[1] https://datanitro.com/blog/2012/07/31/Interactive-Spreadshee...
Whitespace sensitivity is (arguably) a nice developer mind trick, however the target market for VBA are non-developers, who want to google for stuff, copy paste and get on with it. Which means, you cannot make assumptions about things like editors honoring whitespace, as well as the cognitive processes to rely on spacing etc.
This is why I strongly believe Python is the wrong language for this - but some language is definitely needed (Lua ? Javascript? Ruby?)
Which nice-to-write language is most taught in universities?
It's great to see this taking off (and I had no idea it was part of YC until now), and am looking forward to future updates!
Best of luck to the team :)