I am writing a script to pull data from a spreadsheet and use it in an array.
the code looks like this:
@{$sheet->{Cells}[$row]};
my @indexes = (2 .. (2+4-1));
my @dcells = @{$sheet->{Cells}[$row]}[@indexes];
open FILE, ">>feckyou.txt";
foreach (@dcells) {
print FILE ($_);
}
close FILE;
}
I was attempting to print the results of that to that text file so i could
see what data from what cells was being pulled. Instead it prints this to the
file:
Spreadsheet::ParseExcel::Cell=HASH(0x70a49a8)Spreadsheet::ParseExcel::Cell=HASH(0x70a4a08)
it puts one for each item in the cells. How do i get the literal data?
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/