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
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
What I have used it for (Score:1)
In one case I used Spreadsheet::ParseExcel::SaveParser to do the following things:
I remember having to work around a lot of limitations - not sure if they were in the ParseExcel or WriteExcel side. One of them was the hidden tab which you helped me with - at the time it wasn't included in the standard distribution. Another was many cells losing formatting. I ended up having to break encapsulation in quite a few places. I got it all to work but I would never want to have to maintain that code as it was one kludge after another.
The other project I used it for was also on Unix but it was a lot simpler. I needed to parse a bunch of academic papers (scanned PDFs) and extract information from the bibliography. The output was already being put into excel by hand - I just provided the value added of automatically doing so.
Reply to This