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.
please help
ken
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
