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


Keep It Simple, Stupid
	PerlMonks

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

by poj (Abbot)

on Jun 02, 2016 at 06:43 UTC ( [id://1164736]=note: print w/replies, xml )

Need Help??

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

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;
[download]

poj