4 ms·
http://ironspread.com http://ironspread.com can update Excel in real time as well - that's what I'm working on for my next blog post, which will be available so
by vj44 14y ago
http://ironspread.com http://ironspread.com can update Excel in real time as well - that's what I'm working on for my next blog post, which will be available sometime next week.
- mgurlitz 14y agoWhat are the advantages of IronSpread over traditional Python COM access? The API appears only marginally better than Excel's VBA interface, and it looks like IronSpread can't interact with multiple workbooks. The benefit of having the shell launched from within Excel, with no setup needed, disappear when you want to run more complex functions like continual updates. And on top of that IronSpread doesn't support Office 2003.
- karamazov 14y agoRegular COM calls can fail (when Excel is busy, for example), and you can't just click "run" from within Excel, you have to start python from a shell, etc. VBA, on the other hand, is hard to extend - getting it to pull logs from a remote server would be painful. As far as interacting with multiple workbooks, that's something we're working on.