OpenOffice Spreadsheet

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm just trying to read a column in a spreadsheet and create a new
value in a new column to right of the others.
I tried with the following, but it doesn't create the new column, any
hints please

use OpenOffice::OODoc;
my $doc = odfDocument(file => 'iwm.ods');

$row = 3;
while ( my $cli = $doc->cellValue(0, "D$row") ) {
    my $username = get_customer_account( $dbh, $cli );
    print "$cli => $username\n";
    $doc->cellValue(0, "E$row", $username);


It's reading the spreadsheet fine, but it's not inserting the new
value into 'E' column

Re: OpenOffice Spreadsheet

Grehom schrieb:
Quoted text here. Click to load it

$doc->updateCell(0, "E$row", $username);

Re: OpenOffice Spreadsheet

Quoted text here. Click to load it

Thanks, but I had already tried that, the problem I think is that
the table (0) I want to insert a fifth column into is only 4 columns
wide (when I open the spreadsheet you can see bold black outline
around the overall table size), I tried expanding the table but that
only seemed to widen the very last line of the table.  I guess I
should just write a brand new table based on the old table and
delete the old table, but that seems rather crude.

Site Timeline