DateTime::Format::Excel 0.2901
Sponsored Links
DateTime::Format::Excel 0.2901 Ranking & Summary
File size:
0.015 MB
Platform:
Any Platform
License:
Perl Artistic License
Price:
Downloads:
1173
Date added:
2006-08-15
Publisher:
Iain Truskett
DateTime::Format::Excel 0.2901 description
DateTime::Format::Excel is a Perl module that can convert between DateTime and Excel dates.
SYNOPSIS
use DateTime::Format::Excel;
# From Excel via class method:
my $datetime = DateTime::Format::Excel->parse_datetime( 37680 );
print $datetime->ymd(.); # 2003.02.28
# or via an object
my $excel = DateTime::Format::Excel->new();
print $excel->parse_datetime( 25569 )->ymd; # 1970-01-01
# Back to Excel number:
use DateTime;
my $dt = DateTime->new( year => 1979, month => 7, day => 16 );
my $daynum = DateTime::Format::Excel->format_datetime( $dt );
print $daynum; # 29052
# or via an object
my $other_daynum = $excel->format_datetime( $dt );
print $other_daynum; # 29052
Excel uses a different system for its dates than most Unix programs. This module allows you to convert between a few of the Excel raw formats and DateTime objects, which can then be further converted via any of the other DateTime::Format::* modules, or just with DateTimes methods.
If you happen to be dealing with dates between 1 Jan 1900 and 1 Mar 1900 please read the notes on epochs.
If youre wanting to handle actual spreadsheet files, you may find Spreadsheet::WriteExcel and Spreadsheet::ParseExcel of use.
SYNOPSIS
use DateTime::Format::Excel;
# From Excel via class method:
my $datetime = DateTime::Format::Excel->parse_datetime( 37680 );
print $datetime->ymd(.); # 2003.02.28
# or via an object
my $excel = DateTime::Format::Excel->new();
print $excel->parse_datetime( 25569 )->ymd; # 1970-01-01
# Back to Excel number:
use DateTime;
my $dt = DateTime->new( year => 1979, month => 7, day => 16 );
my $daynum = DateTime::Format::Excel->format_datetime( $dt );
print $daynum; # 29052
# or via an object
my $other_daynum = $excel->format_datetime( $dt );
print $other_daynum; # 29052
Excel uses a different system for its dates than most Unix programs. This module allows you to convert between a few of the Excel raw formats and DateTime objects, which can then be further converted via any of the other DateTime::Format::* modules, or just with DateTimes methods.
If you happen to be dealing with dates between 1 Jan 1900 and 1 Mar 1900 please read the notes on epochs.
If youre wanting to handle actual spreadsheet files, you may find Spreadsheet::WriteExcel and Spreadsheet::ParseExcel of use.
DateTime::Format::Excel 0.2901 Screenshot
Advertisements
DateTime::Format::Excel 0.2901 Keywords
DateTime
Excel 0.2901
Perl module
excel dates
Can Convert
excel
dates
convert
module
via
print
DateTime::Format::Excel
DateTimeFormatExcel
DateTime::Format::Excel 0.2901
Libraries
Programming
Bookmark DateTime::Format::Excel 0.2901
DateTime::Format::Excel 0.2901 Copyright
WareSeeker periodically updates pricing and software information of DateTime::Format::Excel 0.2901 full version from the publisher, so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of DateTime::Format::Excel 0.2901 Edition. Download links are directly from our publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed
Featured Software
Want to place your software product here?
Please contact us for consideration.
Contact WareSeeker.com
Related Information
Related Software
DateTime::Format::Epoch is a Perl module that can convert DateTimes to/from epoch seconds. Free Download
DateTime::Format::Pg is a Perl module to parse and format PostgreSQL dates and times. Free Download
DateTime::Format::Epoch::JD is Perl module Convert DateTimes to/from Julian Days. Free Download
DateTime::Format::Epoch::Lilian is a Perl module to convert DateTimes to/from Lilian Days. Free Download
DateTime::Format::Epoch::MJD is a Perl module that can convert DateTimes to/from Modified Julian Days. Free Download
DateTime::Format::Epoch::TJD is a Perl module that can convert DateTimes to/from Truncated Julian Days. Free Download
DateTime::Format::Epoch::RJD is a Perl module that can convert DateTimes to/from Reduced Julian Days. Free Download
DateTime::Format::Epoch::DotNet is a Perl module that can convert DateTimes to/from .NET epoch seconds. Free Download
Latest Software
Popular Software
Favourite Software