http://qs321.pair.com?node_id=236859


in reply to How some people live without Perl

Yes! My 2 main tools for columnar data-munging are Excel and Perl.

Of course, my ideal tool would be a spreadsheet with embedded Perl used for formulas, formatting (sprintf and other transforms), and as the internal macro language...

Cheerio!
Osfameron
http://osfameron.perlmonk.org/chickenman/

Replies are listed 'Best First'.
Re: Re: How some people live without Perl
by John M. Dlugosz (Monsignor) on Feb 19, 2003 at 23:32 UTC
    Sounds like it would be simple to write a spreadsheet in Perl/Tk that basically did that.
[reply]
      Yes, it does sound simple...

      But I don't know enough about Tk. I did start trying to mock something like this up some time ago but I couldn't work out which Tk widget best represented that sort of grid...

      Cheerio!
      Osfameron
      http://osfameron.perlmonk.org/chickenman/

[reply]
Re: Re: How some people live without Perl
by hardburn (Abbot) on Feb 20, 2003 at 15:05 UTC

    I suppose you could put Perl code into formulas using Excel itself, and then use Spreadsheet::Excel and eval any non-Excel formulas.

    ----
    Reinvent a rounder wheel.

    Note: All code is untested, unless otherwise stated

[reply]

In Section Meditations