Hi everyone,

This problem is driving me nuts.
It should be fairly straightforward, but something's wrong.
My .xls file *(not xlsx) has only few values: 

-35, -39, -39, -60, -35, -39, -39,
-36, -40, -40, -59, -36, -40, -40,

[download]

I installed Spreadsheet::Read using Perl Package Manager.
Not ppm install from command line, I used the GUI tool to install it.
My perl version is 5.18.2 (from ActiveState Perl)
(yes i know some people here may crib about it, and I'm on Win 7 OS as well. Chill)
Here is my script: 

use Spreadsheet::Read;
our $workbook = ReadData("tmp.xls", debug => 9);
my ($i,$j)=0;
my @cell;
for($i=1;$i<3;$i++){
    for($j=1;$j<7;$j++){
        $cell[$j] = cr2cell($j, $i); 
        print $workbook->[1]{$cell[$j]};
        print ",";
    }    
    print "\n";
}

[download]

This should have worked.
But instead of printing the values above in my sheet, I just get :
I added the debug flag to understand what's wrong 

$Options = {
             'debug' => 9,
             'strip' => 0,
             'rc' => 1,
             'cells' => 1,
             'dtfmt' => 'yyyy-mm-dd',
             'clip' => 1,
             'attr' => 0
           };
,,,,,,
,,,,,,

[download]

What gives?
What did I do wrong?
Did the PPM miss a dependency or something?
Weird thing is, script works fine on another PC (not mine),
but I don't know what all packages that station has installed in it.
The perl version is the same as mine.
Can anyone shine some light?
Thanks!

In reply to Unable to read values from Excel file by youhaveaBigEgo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.