in reply to reading Excel dates?

Hi Bill, I had this problem too so try something like this:
my $dateVar = $worksheet->Cells( $row, $col )->{Value}; if ( ref $dateVar ) { $theDate = $dateVar->ChangeType(VT_BSTR)->Value(); }
Hopefully, that works for you. Michael

Replies are listed 'Best First'.
Re: Re: reading Excel dates?
by penumbra (Initiate) on May 23, 2004 at 06:28 UTC
    ta for that. Looks like what I want (but I'll try it forst before confirming! :-) ) Bill