http://www.perlmonks.org?node_id=334679


in reply to Favourite modules March 2004

SpreadSheet::Excel.. how i love AND hate thee. excel files in windows excel load up rather quickly, but it is such a bear for doing so with this terrible little module. But alas, it's so terrible, but works so well.

While I love LWP, I wish it were named something a bit.. nicer. When someone asked me on an interview once what it was, Light Weight Process was my immediate answer. Of course, they chuckled as I was told that I did very well on their test, 'cept they meant perl's LWP. (Doh)

Replies are listed 'Best First'.
Re: Re: Favourite modules March 2004
by dragonchild (Archbishop) on Mar 08, 2004 at 02:24 UTC
    Have you taken a look at Excel::Template? It simplifies the creation of Excel files, and uses the same data structure that HTML::Template uses, making Excel-ification of HTML reports quite ... simple. :-)

    ------
    We are the carpenters and bricklayers of the Information Age.

    Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

      Well, for converting from Excel to CSV, it's simple as they give you the example. :) Can't get simpler than that.
Re: Re: Favourite modules March 2004
by Anonymous Monk on Mar 08, 2004 at 02:08 UTC
    While I love LWP, I wish it were named something a bit.. nicer.
    How about something like the "World-Wide Web library for Perl". Then we could shorten it to libwww-perl, or even LWP ;)

    Seriously though, those are two (three if you count both Spreadsheet::ParseExcel and Spreadsheet::WriteExcel) of my favorites - also:

    • DBI
    • DBD::Excel
    • DBD::SQLite