|Perl Monk, Perl Meditation|
Spreadsheet::WriteExcel large filesby mrguy123 (Hermit)
|on Jan 02, 2012 at 08:29 UTC||Need Help??|
mrguy123 has asked for the
wisdom of the Perl Monks concerning the following question:
I am using Spreadsheet::WriteExcel to create a file with 20,000 lines. The size of the file is quite large - over 100 megabytes.
However, when I open the file and save it as a regular Excel file, the file size goes down to 6 megabytes!
I am using fairly standard features (added some of my code just in case)
Any idea why this happens and how I can make the original file smaller?
Bug: An aspect of a computer program which exists because the programmer was thinking about Jumbo Jacks or stock options when he wrote the program.