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.
  • Whenever possible I try to make tab-delimited files and call them .xls. However from time to time you get requests that simply can't be done that way. Perhaps there are issues about forcing the formatting of something that looks like a date. Specific requests for colors. Or having multiple spreadsheets in one file. When I encounter those, I reach for Spreadsheet::WriteExcel.

    Yes, these are boring examples. But were it not for Spreadsheet::WriteExcel, they would be examples that would have forced me to

  • 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