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
help them think they understand.
--Larry Wall
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
Thank you for making the boring possible (Score:1)
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
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