4 ms·
Interestingly, someone recently posted on HN that they're trying to integrate Python into Excel: https://datanitro.com/blog/2013/2/12/future/ https://datanitro.
by csixty4 14y ago
Interestingly, someone recently posted on HN that they're trying to integrate Python into Excel: https://datanitro.com/blog/2013/2/12/future/ https://datanitro.com/blog/2013/2/12/future/
Not ideal, but it's a step up from VBA.
- run4yourlives 14y agoThat's not really what he was saying though. Python was being compared to Perl, and if excel is perl, he wants to see Python, whatever that may be.
- yakiv 14y agoPerl: "There is more than one way to do it." Some ways Excel lets you organize data: (1) chaotically on one worksheet, (2) with different data sets in different worksheets, (3) in tables (http://office.microsoft.com/en-us/excel-help/overview-of-excel-tables-HA010048546.aspx http://office.microsoft.com/en-us/excel-help/overview-of-exc...). Python: "There should be one-- and preferably only one --obvious way to do it." Perhaps Excel/Perl*Python wouldn't have any of Excel's organization tools exactly but would instead have only independent tables that could be made larger and smaller as needed. Edit after reading some comment about databases: Perhaps this program would be a front-end of sorts for databases or could act as one. That might be unrelated to the Perl/Python difference, but it could be a useful feature.
- nickpinkston 14y agoI feel something like subtextual.org may fit this bill. There's some interesting stuff going on there incorporating the text/cell nature of Excel, but with some more intuition.
- protomyth 14y agoI'm sure that's not what csixty4 meant but.... Changing the programming language of Excel from VBA to Python will not do anything except increase the number of articles with Python coding on http://thedailywtf.com http://thedailywtf.com
- rbanffy 14y agoLooks like a better option: http://www.resolversystems.com/products/resolver-one/ http://www.resolversystems.com/products/resolver-one/