I am using this code to try to access certain columns in a spreadsheet to load
into an array for comparison
@{$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;
}
the print is just to see the output. The output looks like this:
Spreadsheet::ParseExcel::Cell=HASH(0x70a49a8)Spreadsheet::ParseExcel::Cell=HASH(0x70a4a08)
how do I access the actual data from the cell?
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/
