Just another perl hacker somewhere near Disneyland
I have this homenode [perlmonks.org] of little consequence on Perl Monks [perlmonks.org] that you probably have no interest in whatsoever.
I also have some modules [cpan.org] on CPAN [cpan.org] some of which are marginally [cpan.org] more [cpan.org] useful [cpan.org] than others.
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::DocTools::UpdateHTML();
ActivePerl::DocToo ls::WriteTOC();
S::WE praise 0 Comments More | Login | Reply /