Hello youhaveaBigEgo,
Check that Spreadsheet::ParseExcel is installed. When I run your script on Strawberry Perl v5.18.2 (on Windows 8.1), using Spreadsheet::Read 0.66, with debug => 5, it works correctly as follows:
16:01 >perl 1684_SoPW.pl $Options = { 'attr' => 0, 'debug' => 5, 'strip' => 0, 'clip' => 1, 'cells' => 1, 'rc' => 1, 'dtfmt' => 'yyyy-mm-dd' }; Opening XLS tmp.xls using Spreadsheet::ParseExcel-0.65 1 sheets Sheet 2 'Sheet1' 2 x 7 -35,-39,-39,-60,-35,-39, -36,-40,-40,-59,-36,-40, 16:01 >
BTW, your C-style for loops would be better written as foreach loops:
for my $i (1 .. 2) { for my $j (1 .. 6) {
Hope that helps,
| Athanasius <°(((>< contra mundum | Iustus alius egestas vitae, eros Piratica, |
In reply to Re: Unable to read values from Excel file
by Athanasius
in thread Unable to read values from Excel file
by youhaveaBigEgo
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |