NAME Spreadsheet::WriteExcel::FromDB - Convert a database table to an Excel spreadsheet SYNOPSIS use Spreadsheet::WriteExcel::FromDB; my $dbh = DBI->connect(...); my $ss = Spreadsheet::WriteExcel::FromDB->read($dbh, $table_name); $ss->ignore_columns(qw/foo bar/); # or $ss->include_columns(qw/foo bar/); $ss->restrict_rows('age > 10'); print $ss->as_xls; # or $ss->write_xls('spreadsheet.xls'); DESCRIPTION This module exports a database table as an Excel Spreadsheet. The data is not returned in any particular order, as it is a simple task to perform this in Excel. However, you may choose to ignore certain columns, using the 'ignore_columns' method. METHODS read Creates a spreadsheet object from a database handle and a table name. dbh / table Accessor / mutator methods for the database handle and table name. restrict_rows $ss->restrict_rows('age > 10'); An optional 'WHERE' clause for restricting the rows returned from the database. ignore_columns $ss->ignore_columns(qw/foo bar/); Output all columns, except these ones, to the spreadsheet. include_columns $ss->include_columns(qw/foo bar/); Only include these columns into the spreadsheet. as_xls print $ss->as_xls; Return the table as an Excel spreadsheet. write_xls $ss->write_xls('spreadsheet.xls'); Write the table to a spreadsheet with the given filename. BUGS Dates are handled as strings, rather than dates. AUTHOR Tony Bowden BUGS and QUERIES Please direct all correspondence regarding this module to: bug-Spreadsheet-WriteExcel-Simple@rt.cpan.org COPYRIGHT AND LICENSE Copyright (C) 2001-2005 Tony Bowden. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. SEE ALSO Spreadsheet::WriteExcel::Simple. Spreadsheet::WriteExcel. DBI