You want to query a relational database and create a file of the results so that another program or person can use them. The two common formats people want to get data in are CSV and Excel.
Use the CPAN module DBIx::Dump to dump the statement handle after the query:
use DBIx::Dump; use DBI; # ... connect to your database as normal $sth = $dbh->prepare("SELECT ..."); # your query here $sth->execute( ); $out = DBIx::Dump->new('format' => $FORMAT, # excel or csv 'output' => $FILENAME, # file to save as 'sth' => $sth); $out->dump( );
The CPAN module DBIx::Dump supports Excel and CSV file formats. It uses the CPAN module Spreadsheet::WriteExcel to write Excel files, and the CPAN module Text::CSV_XS to write CSV files.
The first row in the output files holds the column names. For example:
ID,NAME 1,Nat 2,Tom 4,Larry 5,Damian 6,Jon 7,Dan
The documentation for the CPAN modules DBIx::Dump, Spreadsheet::WriteExcel, and Text::CSV_XS; Recipe 14.17