$oWkS is not a string scalar, it is a reference to a hash (even more specifically, a hash that's been blessed into the class Spreadsheet::ParseExcel::Worksheet); that's really what your object $oWkS is -- a reference to a hash.

What your open call does is attempt to open a file with a certain name for *reading*, but when you put a scalar name into the double-quotes where the scalar refers to a hash, you get back a string that consists of the class name the hash has been blessed into, followed by a bit indicating that this is a hash reference. There is no file with that name, so the call fails.

If you want to read data from the object, you're going to have to access the methods the class provides you with. It *looks* to me like what the data stored in your object is a two-dimensional array, which in Perl is an array of array references. more help than that I cannot responsibly provide, since I'm not at all clear on what you're trying to do.

HTH

In reply to Re: accessing data in a hash by arturo
in thread accessing data in a hash by JSchmitz

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.