Why did you post the same message four times within 10 minutes? It doesn't make people want to help you.
Have you read the documentation for the Spreadsheet::ParseExcel module? You can enter the command 'perldoc Spreadsheet::ParseExcel' or point a browser at <http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.59/lib/Spreadsheet/ParseExcel.pm> The Synopsis has an example of getting the data from a cell: my $cell = $worksheet->get_cell( $row, $col ); print "Value = ", $cell->value(), "\n"; You should use that method. The method you have posted uses the internal data structures of the module and is not documented. On May 28, 2012, at 1:15 PM, Ken Furff wrote: > I am trying to write a script that pulls some data out of certain columns in > a spreadsheet and loads them into an array for comparing and updating. I am > having trouble actually seeing the data, it keeps giving me a HASH message. > the code is this: > @{$sheet->{Cells}$row}; > my @indexes = (2 .. (2+4-1)); > my @dcells = @{$sheet->{Cells}$row}@indexes; > open FILE, ">>forgetyou.txt"; > > foreach (@dcells) { > print FILE ($_); > } > close FILE; > I wanted to print the data from the cell into a text file as a kind of test > to see what columns were coming up etc. and it gives me this: > Spreadsheet::ParseExcel::Cell=HASH(0x70a49a8)Spreadsheet::ParseExcel::Cell=HASH(0x70a4a08)Spreadsheet::ParseExcel::Cell=HASH(0x70a4a98) > over and over, I know this is data from the hash but I dont know how to see > the actual contents of the cell. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
