I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Posted on 2010-05-25 00:14:23.985132-07 by jaiguevara
Spreadsheet access
I'm trying to figure out how to access cells in a Calc spreadsheet. The following creates a spreadsheet with "hello" in cell 0,0... but no "world" in 0,1. What's missing here?
use OpenOffice::OODoc; my $doc = odfDocument( file=>'ttab.ods',create=>'spreadsheet',part=>'content' ); $doc->autoSheetNormalizationOn('full'); my $sheet = $doc->getTable(0, 20, 20); $doc->cellValue($sheet,0,0,"hello"); $doc->cellValue($sheet,0,1,"world"); $doc->save;
Direct Responses: 12722 | Write a response