Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

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)


Comment on Re: Favourite modules March 2004
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
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://334679]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (4)
As of 2014-10-22 04:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (112 votes), past polls