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