3 ms·
This post uses Python. As far as Gnuplot, command line tools are not that powerful on Windows.
by karamazov 14y ago
This post uses Python. As far as Gnuplot, command line tools are not that powerful on Windows.
- acqq 14y agoWhen you really need to script any VBA enabled application on Windows (Excel, Word, you name it) they can be scripted with ActiveState Python or ActiveState Perl which are free and moreover exist for more than a decade: http://www.activestate.com/ http://www.activestate.com/ But to solve the problem described in the article Excel is just not needed.
- vj44 14y agoUnfortunately with activestate you can't run python from within excel, you've got to somehow run the script at the "outside" (be it shell, some other program etc.)
- acqq 14y agoYou can: with a few lines of text a script (be it JScript, Active Python, Active Perl) can be made a COM accessible "object" and can be run from Word and Excel or any other program which has VBA. Visual Studio had that too until Version 2012. Now MS removed VBA infrastructure from the Visual Studio 2012 -- although since 1998 I was able to assign a keypress to run a Perl code from a VS editor to, for example, modify the selection of a C code I develop (I really use such tricks to do non trivial modifications over some bigger piece of code -- pure magic!) So only now in 2012 they killed that in VS. Stupid MS, destroying the best features they already had.
- vonmoltke 14y agoThe Enthought Python Distribution[1] provides tools that can perform all of this analysis, including visualization, fairly easily and in multiple operating systems. [1] http://www.enthought.com/products/epd_free.php http://www.enthought.com/products/epd_free.php