/ 
DBIx-Array-0.23
River stage one • 1 direct dependent • 1 total dependent
/ DBIx::Array::Export

NAME

DBIx::Array::Export - This modules extends DBIx::Array with convenient export functions

SYNOPSIS

use DBIx::Array::Export;
my $dbx=DBIx::Array::Export->new;
$dbx->connect($connection, $user, $pass, \%opt); #passed to DBI

DESCRIPTION

USAGE

METHODS (Export)

xml_arrayhashname

Returns XML given an arrayhashname data structure

$dbx->execute(q{ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD"T"HH24:MI:SS"Z"'});
my @arrayhashname=$dbx->sqlarrayhashname($sql);
my $xml=$dbx->xml_arrayhashname(data    => \@arrayhashname,
                                comment => "Text String Comment",
                                uom     => {col1=>"min", col2=>"ft"});

csv_arrayarrayname

Returns CSV given an arrayarrayname data structure

my $csv=$dbx->csv_arrayarrayname($data);

csv_cursor

Writes CSV to file handle given an executed cursor

binmode($fh);
$dbx->csv_cursor($fh, $sth);

Due to portability issues, I choose not to force the passed file handle into binmode. However, it IS required! For most file handle objects you can run binmode($fh) or $fh->binmode;

xls_arrayarrayname

Returns XLS data blob given an arrayarrayname data structure

my $xls=$dbx->xls_arrayarrayname("Tab One"=>$data, "Tab Two"=>$data2, ...);

TODO

Switch out XML::Simple for XML::LibXML::LazyBuilder

BUGS

Send email to author and log on RT.

SUPPORT

DavisNetworks.com supports all Perl applications big or small.

AUTHOR

Michael R. Davis
CPAN ID: MRDVT
STOP, LLC
domain=>stopllc,tld=>com,account=>mdavis
http://www.stopllc.com/

COPYRIGHT

This program is free software licensed under the...

The BSD License

The full text of the license can be found in the LICENSE file included with this module.

SEE ALSO

Building Blocks

XML::Simple, Text::CSV_XS, Spreadsheet::WriteExcel::Simple::Tabs

Similar Capabilities

Data::Table see csv and tsv methods, Data::Table::Excel