Main > Free Download Search >

Free readable format software for linux

readable format

Sponsored Links
Sponsored Links
Secleted [ 0 ] software to compare
Results 1 - 15 of about 3552
Common Data Format 3.1

Common Data Format 3.1


Common Data Format is a self-describing data abstraction for the storage and manipulation of multidimensional data. more>>
Common Data Format is a self-describing data abstraction for the storage and manipulation of multidimensional data in a platform- and discipline-independent fashion.
It consists of a scientific data management package (known as the "CDF Library") that allows programmers and application developers to manage and manipulate scalar, vector, and multi-dimensional data arrays.
Enhancements:
- Adds new sets of APIs to allow Standard Interface to interact with zVariables and other CDF-related information.
- Adds MingW and FreeBSD ports.
- Adds support for Intel C++ and Fortran for Linux.
- Adds the ability to create legacy CDF 2.7 files.
- Fixes a bug that prevented directories from having .cdf or .skt extensions.
<<less
Download (1.5MB)
Added: 2006-03-13 License: Public Domain Price:
1320 downloads
Test::Reporter::Date::Format 1.27

Test::Reporter::Date::Format 1.27


Test::Reporter::Date::Format Perl module contains date formating subroutines. more>>
Test::Reporter::Date::Format Perl module contains date formating subroutines.

SYNOPSIS

use Test::Reporter::Date::Format;

@lt = localtime(time);

print time2str($template, time);
print strftime($template, @lt);

print time2str($template, time, $zone);
print strftime($template, @lt, $zone);

print ctime(time);
print asctime(@lt);

print ctime(time, $zone);
print asctime(@lt, $zone);

This module provides routines to format dates into ASCII strings. They correspond to the C library routines strftime and ctime.

time2str(TEMPLATE, TIME [, ZONE])

time2str converts TIME into an ASCII string using the conversion specification given in TEMPLATE. ZONE if given specifies the zone which the output is required to be in, ZONE defaults to your current zone.

strftime(TEMPLATE, TIME [, ZONE])

strftime is similar to time2str with the exception that the time is passed as an array, such as the array returned by localtime.

ctime(TIME [, ZONE])

ctime calls time2str with the given arguments using the conversion specification "%a %b %e %T %Yn"

asctime(TIME [, ZONE])

asctime calls time2str with the given arguments using the conversion specification "%a %b %e %T %Yn"

<<less
Download (0.023MB)
Added: 2007-07-24 License: Perl Artistic License Price:
822 downloads
Fortran::Format 0.90

Fortran::Format 0.90


Fortran::Format is a Perl module to read and write data according to a standard Fortran 77 FORMAT. more>>
Fortran::Format is a Perl module to read and write data according to a standard Fortran 77 FORMAT.

SYNOPSYS

use Fortran::Format;

my $f = Fortran::Format->new("2(N: ,I4,2X)");
print $f->write(1 .. 10);
# prints the following:
# N: 1 N: 2
# N: 3 N: 4
# N: 5 N: 6
# N: 7 N: 8
# N: 9 N: 10

# if you dont want to save the format object,
# just chain the calls:
Fortran::Format->new("2(N: ,I4,2X)")->write(1 .. 10);

This is a Perl implementation of the Fortran 77 formatted input/output facility. One possible use is for producing input files for old Fortran programs, making sure that their column-oriented records are rigorously correct. Fortran formats may also have some advantages over printf in some cases: it is very easy to output an array, reusing the format as needed; and the syntax for repeated columns is more concise. Unlike printf, for good or ill, Fortran-formatted fields never exceed their desired width. For example, compare

printf "%3d", 12345; # prints "12345"
print Fortran::Format->new("I3")->write(12345); # prints "***"

This implementation was written in pure Perl, with portability and correctness in mind. It implements the full ANSI standard for Fortran 77 Formats (or at least it should). It was not written with speed in mind, so if you need to process millions of records it may not be what you need.

<<less
Download (0.018MB)
Added: 2007-04-20 License: Perl Artistic License Price:
925 downloads
AnyData::Format::Mp3 0.10

AnyData::Format::Mp3 0.10


AnyData::Format::Mp3 is a tied hash and DBI access to Mp3 files. more>>
AnyData::Format::Mp3 is a tied hash and DBI access to Mp3 files.

SYNOPSIS

use AnyData;
my $playlist = adTie( Passwd, [c:/My Music/] );
while (my $song = each %$playlist){
print $song->{artist} if $song->{genre} eq Reggae
}

OR

use DBI
my $dbh = DBI->connect(dbi:AnyData:);
$dbh->func(playlist,Mp3,[c:/My Music],ad_catalog);
my $playlist = $dbh->selectall_arrayref( qq{
SELECT artist, title FROM playlist WHERE genre = Reggae
});
# ... other DBI/SQL operations

This module provides a tied hash interface and a DBI/SQL interface to MP files. It creates an in-memory database or hash from the Mp3 files themselves without actually creating a separate database file. This means that the database is automatically updated just by moving files in or out of the directories.
Many mp3 (mpeg three) music files contain a header describing the song name, artist, and other information about the music.

Simply choose Mp3 as the format and give a reference to an array of directories containing mp3 files. Each file in those directories will become a record containing the fields:

song
artist
album
year
genre
filename
filesize

This module is a submodule of the AnyData.pm and DBD::AnyData.pm modules. Refer to their documentation for further details.

<<less
Download (0.043MB)
Added: 2006-11-07 License: GPL (GNU General Public License) Price:
1081 downloads
DateTime::Format::Pg 0.15

DateTime::Format::Pg 0.15


DateTime::Format::Pg is a Perl module to parse and format PostgreSQL dates and times. more>>
DateTime::Format::Pg is a Perl module to parse and format PostgreSQL dates and times.

SYNOPSIS

use DateTime::Format::Pg;

my $dt = DateTime::Format::Pg->parse_datetime( 2003-01-16 23:12:01 );

# 2003-01-16T23:12:01+0200
DateTime::Format::Pg->format_datetime($dt);

This module understands the formats used by PostgreSQL for its DATE, TIME, TIMESTAMP, and INTERVAL data types. It can be used to parse these formats in order to create DateTime or DateTime::Duration objects, and it can take a DateTime or DateTime::Duration object and produce a string representing it in a format accepted by PostgreSQL.

CONSTRUCTORS

The following methods can be used to create DateTime::Format::Pg objects.
new( name => value, ... )

Creates a new DateTime::Format::Pg instance. This is generally not required for simple operations. If you wish to use a different parsing style from the default then it is more comfortable to create an object.

my $parser = DateTime::Format::Pg->new()
my $copy = $parser->new( european => 1 );

This method accepts the following options:

european

If european is set to non-zero, dates are assumed to be in european dd/mm/yyyy format. The default is to assume US mm/dd/yyyy format (because this is the default for PostgreSQL).

This option only has an effect if PostgreSQL is set to output dates in the PostgreSQL (DATE only) and SQL (DATE and TIMESTAMP) styles.
Note that you dont have to set this option if the PostgreSQL server has been set to use the ISO format, which is the default.

server_tz

This option can be set to a DateTime::TimeZone object or a string that contains a time zone name.

This value must be set to the same value as the PostgreSQL servers time zone in order to parse TIMESTAMP WITH TIMEZONE values in the PostgreSQL, SQL, and German formats correctly.

Note that you dont have to set this option if the PostgreSQL server has been set to use the ISO format, which is the default.

clone()

This method is provided for those who prefer to explicitly clone via a method called clone().

my $clone = $original->clone();

If called as a class method it will die.

<<less
Download (0.019MB)
Added: 2007-05-17 License: Perl Artistic License Price:
890 downloads
AnyData::Format::XML 0.10

AnyData::Format::XML 0.10


AnyData::Format::XML is a Perl module for tiedhash and DBI access to XML. more>>
AnyData::Format::XML is a Perl module for tiedhash and DBI access to XML.

SYNOPSIS

# access XML data via a multi-dimensional tied hash
# see AnyData.pod for full details
#
use AnyData;
my $table = adTie( XML, $file, $mode, $flags );

OR

# convert data to and from XML
# see AnyData.pod for full details
#
use AnyData;
adConvert( XML, $file1, $any_other_format, $file2, $flags );
adConvert( $any_other_format, $file1, XML, $file2, $flags );

OR

# access the data via DBI and SQL
# see DBD::AnyData.pod for full details
#
use DBI;
my $dbh = DBI->connect( dbi:AnyData );
$dbh->func(mytable,XML,$file,$flags,ad_catalog);
See below for a description of the optional flags that apply to all of these examples.

This module allows you to create, search, modify and/or convert XML data and files by treating them as databases without having to actually create separate database files. The data can be accessed via a multi-dimensional tiedhash using AnyData.pm or via DBI and SQL commands using DBD::AnyData.pm. See those modules for complete details of usage.

The module is built on top of Michel Rodriguezs excellent XML::Twig which means that the AnyData interfaces can now include information from DTDs, be smarter about inferring data structure, reduce memory consumption on huge files, and provide access to many powerful features of XML::Twig and XML::Parser on which it is based.

Importing options allow you to import/access/modify XML of almost any length or complexity. This includes the ability to access different subtrees as separate or joined databases.
Exporting and converting options allow you to take data from almost any source (a perl array, any DBI database, etc.) and output it as an XML file. You can control the formating of the resulting XML either by supplying a DTD listing things like nesting of tags and which columns should be output as attributes and/or you can use XML::Twig pretty_print settings to generate half a dozen different levels of compactness or whitespace in how the XML looks.
The documentaion below outlines the special flags that can be used in either of the interfaces to fine-tune how the XML is treated.

The flags listed below define the relationship between tags and attributes in the XML document and columns in the resulting database. In many cases, you can simply accept the defaults and the database will be built automatically. However, you can also fine tune the generation of the database by specifying which tags and attributes you are interested in and their relationship with database columns.

<<less
Download (0.043MB)
Added: 2006-09-13 License: Perl Artistic License Price:
1137 downloads
Time::Format 1.02

Time::Format 1.02


Time::Format is a Perl module for easy-to-use date/time formatting. more>>
Time::Format is a Perl module for easy-to-use date/time formatting.

SYNOPSIS

use Time::Format qw(%time %strftime %manip);

$time{$format}
$time{$format, $unixtime}

print "Today is $time{yyyy/mm/dd}n";
print "Yesterday was $time{yyyy/mm/dd, time-24*60*60}n";
print "The time is $time{hh:mm:ss}n";
print "Another time is $time{H:mm am tz, $another_time}n";
print "Timestamp: $time{yyyymmdd.hhmmss.mmm}n";
%time also accepts Date::Manip strings and DateTime objects:
$dm = Date::Manip::ParseDate(last monday);
print "Last monday was $time{Month d, yyyy, $dm}";
$dt = DateTime->new (....);
print "Heres another date: $time{m/d/yy, $dt}";
It also accepts most ISO-8601 date/time strings:
$t = 2005/10/31T17:11:09; # date separator: / or - or .
$t = 2005-10-31 17.11.09; # in-between separator: T or _ or space
$t = 20051031_171109; # time separator: : or .
$t = 20051031171109; # separators may be omitted
$t = 2005/10/31; # date-only is okay
$t = 17:11:09; # time-only is okay
# But not:
$t = 20051031; # date-only without separators
$t = 171109; # time-only without separators
# ...because those look like epoch time numbers.
%strftime works like POSIXs strftime, if you like those %-formats.
$strftime{$format}
$strftime{$format, $unixtime}
$strftime{$format, $sec,$min,$hour, $mday,$mon,$year, $wday,$yday,$isdst}

print "POSIXish: $strftime{%A, %B %d, %Y, 0,0,0,12,11,95,2}n";
print "POSIXish: $strftime{%A, %B %d, %Y, 1054866251}n";
print "POSIXish: $strftime{%A, %B %d, %Y}n"; # current time
%manip works like Date::Manips UnixDate function.
$manip{$format};
$manip{$format, $when};

print "Date::Manip: $manip{%m/%d/%Y}n"; # current time
print "Date::Manip: $manip{%m/%d/%Y,last Tuesday}n";
These can also be used as standalone functions:
use Time::Format qw(time_format time_strftime time_manip);

print "Today is ", time_format(yyyy/mm/dd, $some_time), "n";
print "POSIXish: ", time_strftime(%A %B %d, %Y,$some_time), "n";
print "Date::Manip: ", time_manip(%m/%d/%Y,$some_time), "n";

This module creates global pseudovariables which format dates and times, according to formatting codes you pass to them in strings.

The %time formatting codes are designed to be easy to remember and use, and to take up just as many characters as the output time value whenever possible. For example, the four-digit year code is "yyyy", the three-letter month abbreviation is "Mon".

The nice thing about having a variable-like interface instead of function calls is that the values can be used inside of strings (as well as outside of strings in ordinary expressions). Dates are frequently used within strings (log messages, output, data records, etc.), so having the ability to interpolate them directly is handy.

Perl allows arbitrary expressions within curly braces of a hash, even when that hash is being interpolated into a string. This allows you to do computations on the fly while formatting times and inserting them into strings. See the "yesterday" example above.

The format strings are designed with programmers in mind. What do you need most frequently? 4-digit year, month, day, 24-based hour, minute, second -- usually with leading zeroes. These six are the easiest formats to use and remember in Time::Format: yyyy, mm, dd, hh, mm, ss. Variants on these formats follow a simple and consistent formula. This module is for everyone who is weary of trying to remember strftime(3)s arcane codes, or of endlessly writing $t[4]++; $t[5]+=1900 as you manually format times or dates.

Note that mm (and related codes) are used both for months and minutes. This is a feature. %time resolves the ambiguity by examining other nearby formatting codes. If its in the context of a year or a day, "month" is assumed. If in the context of an hour or a second, "minute" is assumed.

The format strings are not meant to encompass every date/time need ever conceived. But how often do you need the day of the year (strftimes %j) or the week number (strftimes %W)?

For capabilities that %time does not provide, %strftime provides an interface to POSIXs strftime, and %manip provides an interface to the Date::Manip modules UnixDate function.

If the companion module Time::Format_XS is also installed, Time::Format will detect and use it. This will result in a significant speed increase for %time and time_format.

<<less
Download (0.038MB)
Added: 2007-07-19 License: Perl Artistic License Price:
830 downloads
Scalable OGo 0.9.0

Scalable OGo 0.9.0


Scalable OGo project (SOGo in short) is a groupware server built around the SOPE application server. more>>
Scalable OGo project (SOGo in short) is a groupware server built around the SOPE application server. Unlike OGo it is focused on scalability instead of depth in functionality. The web interface uses human readable URLs and can be accessed according to REST web service ideas. Notably it requires no server side session at all.

The server stores all internal data in the iCalendar format and therefore has no data model inconsistencies with native clients - it easily connects using GroupDAV connectors.

Scalable OpenGroupware.org is being developed since August 2004.

Important: SOGo is still in pre-alpha quality and is largely undocumented. We do not provide RPM or Debian packaging yet nor expect to be able to build the source without issues.
<<less
Download (MB)
Added: 2006-08-31 License: LGPL (GNU Lesser General Public License) Price:
1152 downloads
DateTime::Format::Roman 0.03

DateTime::Format::Roman 0.03


DateTime::Format::Roman is a Perl module with roman day numbering for DateTime objects. more>>
DateTime::Format::Roman is a Perl module with roman day numbering for DateTime objects.

SYNOPSIS

use DateTime::Format::Roman;

my $formatter = DateTime::Format::Roman->new(
pattern => %d %f %b %y );

my $dt = DateTime->new( year => 2003, month => 5, day => 28 );

$formatter->format_datetime($dt);
# 5 Kal Jun 2003

This module formats dates in the Roman style.

The Romans expressed their dates in relation to three fixed dates per month. For example: the Ides of March was the 15th of that month; 14 March was called "2 Ides", 13 March was called "3 Ides", etcetera. The days in the second half of the month were named after the first day of the next month, the "Kalends"; e.g. 16 March was called "17 Kalends of April".

METHODS

new( pattern => $string )

Creates a new formatter object. The optional formatting pattern defines the format of the output of format_datetime(). If no formatting pattern is given, a reasonable default is used.

format_datetime($datetime)

Retruns the formatted string. This method can be called on a formatter object (created by new()), or it can be called as a class method. In the latter case, the default pattern is used.

PATTERN SPECIFIERS

The following specifiers are allowed in the format strings given to the new() method:

%b

The abbreviated month name.

%B

The full month name.

%d

The day of the month as a decimal number (including 1 for the fixed days).

%D

The day of the month, written as a number plus the corresponding fixed day.

%f

The fixed day part of the date.

%m

The month as a decimal number (range 1 to 12).

%y

The year as a decimal number.

If a specifier is preceded by O or o, numbers will be written in uppercase and lowercase Roman numerals, respectively.

The %f specifier accepts an additional argument of 1 digit, specifying the length of the output:

%0f : abbreviated name (e.g. "Kal")
%1f : full name (e.g. "Kalends")
%2f : one-letter abbreviation (e.g. "K")

<<less
Download (0.011MB)
Added: 2007-08-14 License: Perl Artistic License Price:
801 downloads
DateTime::Format::Epoch 0.10

DateTime::Format::Epoch 0.10


DateTime::Format::Epoch is a Perl module that can convert DateTimes to/from epoch seconds. more>>
DateTime::Format::Epoch is a Perl module that can convert DateTimes to/from epoch seconds.

SYNOPSIS

use DateTime::Format::Epoch;

my $dt = DateTime->new( year => 1970, month => 1, day => 1 );
my $formatter = DateTime::Format::Epoch->new(
epoch => $dt,
unit => seconds,
type => int, # or float, bigint
skip_leap_secondss => 1,
start_at => 0,
local_epoch => undef,
);

my $dt2 = $formatter->parse_datetime( 1051488000 );
# 2003-04-28T00:00:00

$formatter->format_datetime($dt2);
# 1051488000

This module can convert a DateTime object (or any object that can be converted to a DateTime object) to the number of seconds since a given epoch. It can also do the reverse.

<<less
Download (0.017MB)
Added: 2006-08-15 License: Perl Artistic License Price:
1168 downloads
Audio Format Converter 0.7.0

Audio Format Converter 0.7.0


Audio Format Converter is a an Amarok script that allows you to convert the audio format of the tracks in the playlist. more>>
Audio Format Converter is a an Amarok script that allows you to convert the audio format of the tracks in the playlist. The script takes a snapshot of the current playlist. Once the conversion has started, you can go back to using amaroK normally.

Supported files for both input and output include .flac, .ogg, .mp3, .mpc, .m4a, and .wav. Additionally, .wma, .ra, and are supported for input. (See below for the required packages.)

I dont know how to do anything with metatags from .wma or .ra. All I know is tags will get transferred to the output file if and only if the tags show up in the amaroK playlist. If they arent there, I suggest converting the files, then using a real tag editor like Easy Tag to put them in to the converted files.

This has only been tested on amaroK 1.2.4, but it should work on any amaroK>=1.2

The original files are NOT deleted. If the output file will overwrite an existing file, a dialog will appear to ask you whether to go ahead and overwrite or to skip the track. If you try to convert a file into the format its already in, a dialog will ask you how to handle this situation.

Depending on the number of tracks and the speed of your computer, this can take a long time to run. With each track, a passive popup will let you know what track its processing. At any time, you can stop the script by clicking stop in the amaroK script GUI.

<<less
Download (0.006MB)
Added: 2007-04-30 License: GPL (GNU General Public License) Price:
914 downloads
readcdda 1.003

readcdda 1.003


readcdda is a Perl module that reads digital audio from a CD. more>>
readcdda is a Perl module that reads digital audio from a CD.

SYNOPSIS

readcdda [OPTION]...

This is a program to read (or "rip") CD digital audio from a CD and output the PCM data. Typically this is an initial stage in encoding data to MP3 format.

The output data is raw 16 bit 44.1kHz stereo data. This format is directly readable by software like sox and various MP3 encoders, e.g.:

readcdda -Dsg3 -v -F |sox -r44100 -c2 -tsw - -twav %02d.wav

Will read a CD and create WAV files in the current directory with names 00.wav..99.wav. Alternatively, you can read and encode directly to MP3 with something like:

readcdda -Dsg3 -v -F |mp3enc -v -sti -of %02d.mp3 -br 160000 -qual 6

-D, --dev, --device=DEVICE

SCSI device name or number to use.

-L, --list

Prints a list of all CD devices and their name/number, then exits.

-T, --toc

Prints a list of tracks on the CD, then exits.

-f, --first=TRACK

Selects the first track to read. Defaults to the first track on the CD.

-l, --last=TRACK

Selects the last track to read. Defaults to the same as -f if that was selected (i.e. read just one track) or the last track on the CD if it was not (i.e. read the whole CD.)

-d, --dir, --directory=DIR

Output is saved in this directory, with names of "00".."99".

-s, --stdout

Output is sent to standard output.

-F, --format=FORMAT

Output is sent to a name generated by a printf()-style format, e.g. "%02d".

-v, --verbose

Gives progress reports.

-V, --version

Givess script and module versions and exits.

-h, --help

Prints this text and exits.

<<less
Download (0.009MB)
Added: 2006-06-22 License: Perl Artistic License Price:
1219 downloads
File::Format::RIFF 1.0.1

File::Format::RIFF 1.0.1


File::Format::RIFF is a Perl module to Resource Interchange File Format/RIFF files. more>>
File::Format::RIFF is a Perl module to Resource Interchange File Format/RIFF files.

SYNOPSIS

use File::Format::RIFF;

open( IN, file ) or die "Could not open file: $!";
my ( $riff1 ) = File::Format::RIFF->read( *IN );
close( IN );
$riff1->dump;

my ( $riff2 ) = new File::Format::RIFF( TYPE );
foreach my $chunk ( $riff1->data )
{
next if ( $chunk->id eq LIST );
$riff2->addChunk( $chunk->id, $chunk->data );
}
open( OUT, ">otherfile" ) or die "Could not open file: $!";
$riff2->write( *OUT );
close( OUT );

File::Format::RIFF provides an implementation of the Resource Interchange File Format. You can read, manipulate, and write RIFF files.

CONSTRUCTORS

$riff = new File::Format::RIFF( $type, $data );

Creates a new File::Format::RIFF object. $type is a four character code that identifies the type of this particular RIFF file. Certain types are defined to have a format, specifying which chunks must appear (e.g., WAVE files). If $type is not specified, it defaults to (four spaces). $data must be an array reference containing some number of RIFF lists and/or RIFF chunks. If $data is undef or not specified, then the new RIFF object is initialized empty.

$riff = File::Format::RIFF->read( $fh, $filesize );

Reads and parses an existing RIFF file from the given filehandle $fh. An exception will be thrown if the file is not a valid RIFF file. $filesize controls one aspect of the file format checking -- if $filesize is not specified, then stat will be called on $fh to determine how much data to expect. You may explicitly specify how much data to expect by passing in that value as $filesize. In either case, the amount of data read will be checked to make sure it matches the amount expected. Otherwise, it will throw an exception. If you do not wish it to make this check, pass in undef for $filesize.

Please note, if you wish to read an "in memory" filehandle, such as by doing this: open( $fh, read( $fh, $filesize );

The read constructor may also be used as a method. If used in this manner, then all existing data contained in $riff will be discarded, and replaced by the contents read from $fh.

$riff->write( $fh );

Outputs a properly-formatted RIFF file to the given filehandle $fh.

<<less
Download (0.009MB)
Added: 2007-04-27 License: Perl Artistic License Price:
916 downloads
DBIx::SQLCrosstab::Format 1.17

DBIx::SQLCrosstab::Format 1.17


DBIx::SQLCrosstab::Format is a Perl module with formats results created by DBIx::SQLCrosstab. more>>
DBIx::SQLCrosstab::Format is a Perl module with formats results created by DBIx::SQLCrosstab.

SYNOPSIS

use DBIx::SQLCrosstab::Format;
my $dbh=DBI->connect("dbi:driver:database"
"user","password", {RaiseError=>1})
or die "error in connection $DBI::errstrn";

my $params = {
dbh => $dbh,
op => [ [ SUM, salary] ],
from => person INNER JOIN departments USING (dept_id),
rows => [
{ col => country},
],
cols => [
{
id => dept,
value =>department,
from =>departments
},
{
id => gender, from => person
}
]
};
my $xtab = DBIx::SQLCrosstab::Format->new($params)
or die "error in creation ($DBIx::SQLCrosstab::errstr)n";

my $query = $xtab->get_query("#")
or die "error in query building $DBIx::SQLCrosstab::errstrn";

if ( $xtab->get_recs) {
# do something with records, or use a built-in function
# to produce a well formatted HTML table
#
print $xtab->as_html;

print $xtab->as_xml;
print $xtab->as_yaml;
print $xtab->as_csv(header);
$xtab->as_xls("xtab.xls");
use Data::Dumper;
print Data::Dumper->Dump ([ $xtab->as_perl_struct(hoh)],
[hoh]);
print Data::Dumper->Dump ([ $xtab->as_perl_struct(losh)],
[losh]);
print Data::Dumper->Dump ([ $xtab->as_perl_struct(loh)],
[loh]);
}
else {
die "error in execution $DBIx::SQLCrosstab::errstrn";
}

DBIx::SQLCrosstab::Format is a class descending from DBIx::SQLCrosstab. Being a child class, it inherits its parent methods and can be used in the same way.

In addition, it provides methods to produce formatted output.

<<less
Download (0.065MB)
Added: 2006-09-27 License: Perl Artistic License Price:
1122 downloads
DateTime::Format::Excel 0.2901

DateTime::Format::Excel 0.2901


DateTime::Format::Excel is a Perl module that can convert between DateTime and Excel dates. more>>
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.

<<less
Download (0.015MB)
Added: 2006-08-15 License: Perl Artistic License Price:
1169 downloads
Secleted [ 0 ] software to compare
  • Page: 1 of 5
  • 1
  • 2
  • 3
  • 4
  • 5