Stories
Slash Boxes
Comments
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

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • In one case I used Spreadsheet::ParseExcel::SaveParser to do the following things:

    • Generate Excel file on Unix
    • Create a chart using a hidden data tab
    • Fancy formatting on a multi-tab workbook

    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.