Excel Data conversion

[Hans Kohls]

Hello,

I have to convert the (afaik) Excel (internal) date format into a
different format.
I am wondering if there is a package around to do so. The excel Format
is something like 3NNNN and represents the number of days since 1.1.1900.

Cheers, Hans

[Bill Karwin]

Hans Kohls wrote:

> I have to convert the (afaik) Excel (internal) date format into a
> different format.
> I am wondering if there is a package around to do so. The excel Format
> is something like 3NNNN and represents the number of days since 1.1.1900.

DateTime::Format::Excel is a module intended to do this conversion.

[url]http://search.cpan.org/dist/DateTime-Format-Excel/lib/DateTime/Format/Excel.pm[/url]

Regards,
Bill K.

[Joe Smith]

Hans Kohls wrote:

> Hello,
>
> I have to convert the (afaik) Excel (internal) date format into a
> different format.
> I am wondering if there is a package around to do so. The excel Format
> is something like 3NNNN and represents the number of days since 1.1.1900.

linux% perl -e 'use Date::Calc qw(Add_Delta_Days); \
printf "%4d/%02d/%02d\n",Add_Delta_Days(1900,1,1,31245)'
1985/07/19

-Joe

[John McNamara]

On Tue, 27 Jul 2004 18:03:28 GMT, Joe Smith wrote:

>> Hans Kohls wrote:
>>
>> I have to convert the (afaik) Excel (internal) date format into a
>> different format.
>> I am wondering if there is a package around to do so. The excel Format
>> is something like 3NNNN and represents the number of days since 1.1.1900.

> linux% perl -e 'use Date::Calc qw(Add_Delta_Days); \
> printf "%4d/%02d/%02d\n",Add_Delta_Days(1900,1,1,31245)'
> 1985/07/19

That is out by 2 days because:

1. the epoch is actually 0 January 1900!
2. 1900 is treated as a leapyear by Excel!!

Mind-boggling stuff is it not.

The following gives the right dates from 1 March 1900 onwards:

... Add_Delta_Days(1899, 12, 30, $excel_date);

John.
--
perl -MCPAN -e 'install jmcnamara & _ x ord $ ;' | tail -1