develooper Front page | perl.beginners | Postings from September 2008

getCellValue

From:
Xavier Mas
Date:
September 5, 2008 01:21
Subject:
getCellValue
Dear all,

I need to get the numeric values of a spreadsheet (that actually are the 
numeric values of a "button radio" field from an exported data base to .ods).

When I try to get the value of the cell  using 'getCellValue', the program 
gives wrong values or none value at all; if I print the number of row and 
column are correct, but 'getCellValue' gives an incorrect result.

Additionally, if I don't stop the program manually continues indefinitely, 
beyond the end of the spreadsheet.

Any suggestions?

		while($valor_numeric ne '*****') { 
		$num_fila++;
		#gets column number from a hash.
		my $num_columna= $camps{$categoria}; 
		print "$categoria, $num_columna\n";
		my $valor_numeric= $doc->getCellValue(0, $num_fila, $num_columna);
		print "$num_fila, $num_columna, $categoria, $valor_numeric\n";
		my $valor_alfanumeric= $categoria{$valor_numeric};
 		chomp($valor_alfanumeric);
 		$doc->updateCell(0, $num_fila, $num_columna, $valor_numeric,
		$valor_alfanumeric);
		$doc->save('my_other_file.ods');
			}

-- 
Xavier Mas

		
______________________________________________ 
LLama Gratis a cualquier PC del Mundo. 
Llamadas a fijos y móviles desde 1 céntimo por minuto. 
http://es.voice.yahoo.com




nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About