Re: Jakarta-Poi and Inline::Java: problems transfering large arrays from java to perl

2004-01-30 Thread Heiko Klein
Thanks for your answer. Problem with most of the Excel stuff on CPAN, it is (as far as I could see) based upon Spreadsheet::ParseExcel. As Stephen pointed out, there is Spreadsheet::ParseExcel_xlhtml which uses an xlhtml as external parser. This is then quite similar to your 'wrapper' solutions

Re: Jakarta-Poi and Inline::Java: problems transfering large arrays from java to perl

2004-01-29 Thread Stephen R. Wilcoxon
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 ac

Re: Jakarta-Poi and Inline::Java: problems transfering large arrays from java to perl

2004-01-29 Thread Patrick LeBoutillier
Heiko, 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 = 20 elements, so that's why it's slow. He

Jakarta-Poi and Inline::Java: problems transfering large arrays from java to perl

2004-01-28 Thread Heiko Klein
Hi, I have to read large Excel-files (5sheet, 4000rows, 50columns) with perl. Misereably, the Spreadsheet::ParseExcel modules is really slow and memory hungry on this (> 5min parsing, > 250MB memory). Therefore I've been looking around and found the nice jakarta POI project, handling exactly t