good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Spreadsheet::WriteExcel Too Many Formats Problemsby water (Deacon) |
on Jun 02, 2006 at 01:14 UTC ( [id://553196]=perlquestion: print w/replies, xml ) | Need Help?? |
water has asked for the wisdom of the Perl Monks concerning the following question:
Hi --
I am using Spreadsheet::WriteExcel to make a sheet with several tabs, each tab with many populated cells, and many cells with multiple formats (color, currency, etc). I am applying the formats cell-wise, not row- or col- or region-wise. If the sheet gets too big, it seems I am overflowing some sort of Excel max-num-formats-applied limit: an excel warning error gets issued on spreadsheet open, and the resulting sheet 'loses' formatting somewhere along the way in one of the later tabs. Has anyone else encountered this over-use of Excel format problem, and have any suggestions to remedy it? Thanks!
Back to
Seekers of Perl Wisdom
|
|