3 ms·
"There is pretty much no decent scripting language available on Windows, so if you do not have immediate access to some unix (or at least cygwin), you're out of
by acqq 14y ago
"There is pretty much no decent scripting language available on Windows, so if you do not have immediate access to some unix (or at least cygwin), you're out of luck."
He seems to be fully uniformed about what he writes about. The graphs he produced in Excel can be produced without Excel and just with open-source tools on practically any platform. Python and Gnuplot can be installed anywhere:
http://www.python.org/ http://www.python.org/
"Python runs on Windows, Linux/Unix, Mac OS X, and has been ported to the Java and .NET virtual machines."
http://www.gnuplot.info/ http://www.gnuplot.info/
"Gnuplot is a portable command-line driven graphing utility for Linux, OS/2, MS Windows, OSX, VMS, and many other platforms."
- karamazov 14y agoThis 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
- est 14y ago> There is pretty much no decent scripting language available on Windows Hmm, how about JScript? All excel files can be manipulated via COM.
- captaintacos 14y agoI think you all are missing this little line here: "I did not want my script to require any technical knowledge, so that non-techies (business people, marketing, sales team etc.) could just press a button and see the results of their work" Most of us in here know the results of this tutorial can be reproduced with one single line in bash and a perl script. But try telling a non-techie guy to get that command working. If you did set up the environment for them beforehand it's all frosty. But if not... that would require introducing them to the command line, perl or python AND the INSTALLATION of their respective modules needed to work with Excel. Just to install perl on windows would mean having to send them on an odyssey through: strawberry, activestate, cygwin, etc and then hope for the best when they get to the module installation part. That IronSpread thing sure is quite interesting. Too bad it is not supported by Excel 2003 (yup, I'm in a legacy box here)
- acqq 14y agoJScript is already installed on every Windows including XP, it can access and parse files, it has most of Perl regexp goodness so you could still have a one click, again without installing IronSpread. And that would work with your Excel 2003 too.
- jmount 14y agoR http://cran.r-project.org/ http://cran.r-project.org/ is scriptable, install anywhere and can make plots.
- wslh 14y agoDecent scripting language on windows? Powershell...