Re: Reading Date Formatted Excel Cell

"Win32::OLE::Variant=SCALAR(0x29093f8)" means you've got a Win32::OLE::Variant object, not a number or string value. reading the docs you should probably use the Date() method:

print $date_req->Date("ddd',' MMM dd yy"), "\n";
[download]

I don't have a win32 w/ perl available to me at the moment, so I haven't tested this.

"What should it profit a man, if he should win a flame war, yet lose his cool?"

Comment on Re: Reading Date Formatted Excel Cell Download Code

Replies are listed 'Best First'.
Re^2: Reading Date Formatted Excel Cell by merrymonk (Hermit) on Mar 05, 2007 at 19:31 UTC
That worked and gave 'Thu, Mar 01 07' which is correct I should also have said that I wanted it in the form dd/mm/yy that is 01/03/07 Therefore I changed this to >Date("dd/mm/yy") This nearly worked since it gave 01/mm/07 What should mm be replaced by?	[reply]
Re^3: Reading Date Formatted Excel Cell by Joost (Canon) on Mar 05, 2007 at 20:13 UTC
I'm not sure, since I can't test it, but my guess would be "MM" instead of "mm". It should be in the docs (linked in my post above) "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re^4: Reading Date Formatted Excel Cell by merrymonk (Hermit) on Mar 05, 2007 at 20:29 UTC
The 'docs' say MM. I will try tomorrow Many thanks!	[reply]
Re^4: Reading Date Formatted Excel Cell by merrymonk (Hermit) on Mar 07, 2007 at 08:30 UTC
MM worked as suggested Many thanks	[reply]