yy).
Max
NYIMI Jose (BMB) wrote:
$oSheetCR->Value #formatted value
$oSheetCR->{Val} #original value
José.
-Original Message-
From: Max [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 4:50 PM
To: [EMAIL PROTECTED]
Subject: Spreadsheet::ParseExcel date problem (year
EMAIL PROTECTED]
From: Max <[EMAIL PROTECTED]>
To: Mystik Gotan <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Spreadsheet::ParseExcel date problem (year is being
reformatted)
Date: Thu, 12 Dec 2002 10:10:16 +0100
My e-mail was changed, I use bold to highlight yy (02) and yyy
$oSheetCR->Value #formatted value
$oSheetCR->{Val} #original value
José.
> -Original Message-
> From: Max [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 10, 2002 4:50 PM
> To: [EMAIL PROTECTED]
> Subject: Spreadsheet::ParseExcel date problem (year is
y now how to prevent this?
Mystik Gotan wrote:
Regex?
$var =~ s/\b\**\**\b//; # deletes *
--
Bob Erinkveld (Webmaster Insane Hosts)
www.insane-hosts.net
MSN: [EMAIL PROTECTED]
From: Max <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Spreadsheet::ParseExcel date probl
Regex?
$var =~ s/\b\**\**\b//; # deletes *
--
Bob Erinkveld (Webmaster Insane Hosts)
www.insane-hosts.net
MSN: [EMAIL PROTECTED]
From: Max <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Spreadsheet::ParseExcel date problem (year is being reformatted)
Date: Tue,
When I read an Excel file in, ParseExcel reformates the year to
dd-mm-*yy* (for example 10 dec 2002 is 10-12-*02*).
I don't want this to happen, the format should stay the way it was
dd-mm-** (10-12-*2002*).
Here is the code:
use Spreadsheet::ParseExcel;