On Thu 2004/01/29 08:13:43 CST, "Patrick LeBoutillier" <[EMAIL PROTECTED] tmail.com> writes: > > The reason you are having performance problems is that Inline::Java does > not actually transfer > the array over to Perl. It actually sends a 'reference' to it an calls > Java each time you want to access an element. In your case you have 4000 * > 50 = 200000 elements, so that's why it's slow. > > Here are things your could try: > > - More Perl-Excel stuff: http://search.cpan.org/search?m=all&q=Excel&s=1
I would greatly recommend Spreadsheet::ParseExcel_XLHTML. I was having similar problems with Spreadsheet::ParseExcel (very slow and huge memory usage) but _XLHTML fixed all that. It runs about 20 times faster and uses MUCH less memory. The only non-perl requirement is that you must have xlhtml installed on your system.
