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.

[reply]
      Well, for converting from Excel to CSV, it's simple as they give you the example. :) Can't get simpler than that.
[reply]
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
[reply]

In Section Meditations