Just another perl hacker somewhere near Disneyland
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):