OpenOffice Spreadsheet

[Grehom]

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);
$row++;
}

$doc->save();


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

 

[Chris Haffenstedt]

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);
$row++;
}

$doc->save();


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

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

 

[Grehom]

Grehomschrieb:






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

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.