----- Original Message -----
From: "Carl Jolley" <[EMAIL PROTECTED]>
To: "Sisyphus" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "rotaiv" <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 3:27 AM
Subject: Re: Problems reading Excel date format
> On Tue, 26 Jun 2001, Sisyphus wrote:
>
> >
> > ----- Original Message -----
> > From: "rotaiv" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, June 26, 2001 1:48 AM
> > Subject: Re: Problems reading Excel date format
> >
> >
> > > At 06/25/2001 11:08 AM, Sisyphus wrote:
> > >
> > > >It's a scalar reference. Assuming this is the value held by $cell, to
> > > >dereference it:
> > > >$deref = \$cell;
> > > >print $deref;
> > >
> > > I neglected to mention I tried that already - this is what happened:
> > >
> > > print $cell;
> > > Win32::OLE::Variant=SCALAR(0x1bd25c4)
> > >
> > > print \$cell;
> > > SCALAR(0x1bd2510)
> > >
> > > Agreed, it is a slightly different result but still does not help me.
> > >
> > > rotaiv
> > >
> > > _______________________________________________
> >
> > You need to dereference once more to get at the value:
> >
> > $deref2 = \$deref;
> > print $deref2;
> >
> > It is possible that you will find that the 'value' is not what you
expect.
> > You'd have to hunt through the docs to find out just what it is that
> > "{'value'}" contains - unless someone who knows the answer comes
forward.
> > (Every time I see 644 in a string, I start thinking 'permissions' - it's
a
> > conditioned response :-)).
> >
> > Cheers,
> > Rob
> >
>
> I'm not sure how this sort of thing gets started but I seen it more
> the once so apparently it has a life of its own.
>
> The backwards slash in front of a variable does NOT dereference it.
> Quite the opposite, it generates a reference to the variable.
>
> To dereference a reference it should be preceed with the initial
> character of the variable type that the reference represents.
> E.G. to deference a scalar variable which is held in the variable
> $ref one would use $$ref or ${$ref}.
>
> **** [EMAIL PROTECTED] <Carl Jolley>
> **** All opinions are my own and not necessarily those of my employer ****
>
>
Whooo............. Someone better tell rotaiv !!!
Poor guy's been "dereferencing" for the last 24 hours solid - still getting
scalar references :-))
(Sorry, mate.... you can stop now.)
Should teach me to think carefully before I post....or at least check my
sources (especially if it's documentation that I've put together).
Cheers,
Rob
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
