Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

runrig (3385)


Just another perl hacker somewhere near Disneyland

I have this homenode [] of little consequence on Perl Monks [] that you probably have no interest in whatsoever.

I also have some modules [] on CPAN [] some of which are marginally [] more [] useful [] than others.

Journal of runrig (3385)

Tuesday March 22, 2005
05:13 PM

S::WE praise

[ #23797 ]

I come to sing the praises of Spreadsheet::WriteExcel (and DBI, as always). I recieved some data in an Excel spreadsheet, which needed to be categorized, so I figured (having no specs to go by) that the best way to return it would be a multi-sheet Excel spreadsheet. And it was a snap.

Update: Interesting note...the original spreadsheet was ~1MB, while the spreadsheet I generated, which contained all the original data plus a couple of extra columns, was only 500K.

Only complaint is with ActiveState's ppm repository which often seems to install modules a version behind, even though it says it's installing the latest. So I just download from cpan and (n)make/install, but that leaves ActiveState's html documentation out of sync, so (so far) my solution is to delete the html docs, and run (from digging through their installation scripts):

require ActivePerl::DocTools;

ActivePerl::DocToo ls::WriteTOC();

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.