Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Excel file manipulation in HPUX system
- Jim Chiang
October 14, 2004, 12:13 pm
rate this thread
Re: Excel file manipulation in HPUX system
> Can anyone comment on the performance aspect of reading and
> writing large Excel files with these modules?
Here are some personal observations on the performance of these
* Instantiating an Excel automation object has a large overhead. As
such it is better suited to once-off or one-at-a-time usage then as a
* Writing data is a lot faster if you use the Range() method as
opposed to one cell at a time:
my $range = $worksheet->Range("A1:B4");
$range-> = \@data;
* Generally fast for creating files.
* Use Spreadsheet::WriteExcel::Big for file over 7MB.
* In the 2.xx versions (Excel97), all unique strings to be written are
stored in memory. Thus, performance will degrade when writing files
with a large amount of unique string data. There is no degradation
related to writing numbers.
* Writing formulas is slow due to the overhead of Parse::RecDescent.
Use the store_formula() and repeat_formula() methods if you need to
write a lot of similar formulas. See "Improving performance when
working with formulas" in the docs:
* Can be very memory intensive when dealing with large files. See
"Reducing the memory usage of Spreadsheet::ParseExcel":
But as always when you are interested in performance the best thing to
do is to write some benchmarks. :-)
- » Problems when installing Template Toolkit on Activestate
- — Previous thread in » PERL Modules Announcements