Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: OpenOffice::OODoc. Slow access to a cell content with getCellValue

by pvaldes (Chaplain)
on Jun 01, 2016 at 22:33 UTC ( [id://1164724]=note: print w/replies, xml ) Need Help??


in reply to Re: OpenOffice::OODoc. Slow access to a cell content with getCellValue
in thread OpenOffice::OODoc. Slow access to a cell content with getCellValue

Much faster Poj, only 11 minutes running (against "infinite minutes"), but the outfile.txt was totally empty after this time. Something is wrong :-(

Replies are listed 'Best First'.
Re^3: OpenOffice::OODoc. Slow access to a cell content with getCellValue
by poj (Abbot) on Jun 02, 2016 at 06:43 UTC

    I used this to create a simple test file

    #!/usr/bin/perl use strict; use OpenOffice::OODoc; my $doc = odfDocument( file => 'testspreadsheet.ods', create => 'spreadsheet'); $doc->expandTable(0,5,10); for my $r (0..4){ for my $c (0..9){ $doc->cellValue(0,$r,$c,"text at ".chr(65+$c).($r+1)); } } $doc->save;
    poj
Re^3: OpenOffice::OODoc. Slow access to a cell content with getCellValue
by pvaldes (Chaplain) on Jun 02, 2016 at 11:24 UTC

    Update: It seems that there was problem with the memory when I run your script, Poj. This problem could or could not be related with the perl job.

    I'm running again the script with the -d option. When It hits the line

     my $table = $doc->getTable($sheetno,'normalize');

    The perl script uses the 99-100% of CPU and the 10% of memory. After some minutes the memory consume raises to 81-83% until finally the computer frozens and the process is automatically killed without finishing the job. This takes 6-11 min and explains why outfile.txt is empty. It seems that my spreadsheet file is a hard nut to open. I wonder why.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1164724]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2024-03-28 19:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found