Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: Favourite modules March 2004

by exussum0 (Vicar)
on Mar 07, 2004 at 22:03 UTC ( #334679=note: print w/replies, xml ) Need Help??

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://334679]
[shmem]: do you have the mysqlclient libs on that device, for instance?
[shmem]: and btw, your original questian is an XY Problem classic ;-)
[Spenser]: yes, I have mysql client libs installed.

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (9)
As of 2018-03-17 12:52 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (224 votes). Check out past polls.