Spreadsheet::WriteExcel::FromDB::Query - Convert a database query to an Excel spreadsheet

Spreadsheet-WriteExcel-FromDB-Query documentation Contained in the Spreadsheet-WriteExcel-FromDB-Query distribution.

Index

Code Index:

NAME

Top

Spreadsheet::WriteExcel::FromDB::Query - Convert a database query to an Excel spreadsheet

SYNOPSIS

Top

  use Spreadsheet::WriteExcel::FromDB::Query;

  my $dbh = DBI->connect(...);

  $query = q{select user from users};
  my $ss = Spreadsheet::WriteExcel::FromDB->read($dbh, $query);

  print $ss->as_xls;
  # or
	$ss->write_xls('spreadsheet.xls');

DESCRIPTION

Top

This module exports a database query as an Excel Spreadsheet. It functions very similar to Spreadsheet::WriteExcel::FromDB, except that it forms the Excel spreadsheet from a query instead of an entire table.

METHODS

Top

_data_query

Returns the query directly to Spreadsheet::WriteExcel::FromDB

_columns_in_table

Returns the columns from the query directly to Spreadsheet::WriteExcel::FromDB

BUGS

Top

The same bugs that apply to Spreadsheet::WriteExcel::FromDB also apply to Spreadsheet::WriteExcel::FromDB::Query. Dates are handled as strings, rather than dates.

AUTHOR

Top

Christopher Kois, <cpkois@cpan.org>

COPYRIGHT AND LICENSE

Top

Copyright (C) May, 2006 Christopher Kois.

This module is Copyright (c) 2006 by Christopher Kois. http://www.christopherkois.com All rights reserved. You may distribute this module under the terms of GNU General Public License (GPL).

The Spreadsheet::WriteExcel::FromDB::Query is a subclass derived from the Spreadsheet::WriteExcel::FromDB module, Copyright (C) 2001-2005 by Tony Bowden.

Module Copyrights: - The Spreadsheet::WriteExcel::FromDB module is Copyright © 2001-2005, Tony Bowden. Available at: http://search.cpan.org/~tmtm/Spreadsheet-WriteExcel-FromDB-1.00/lib/Spreadsheet/WriteExcel/FromDB.pm - The Spreadsheet::WriteExcel::Simple module is Copyright © 2001-2005, Tony Bowden. Available at: http://search.cpan.org/~tmtm/Spreadsheet-WriteExcel-Simple-1.04/Simple.pm

SUPPORT/WARRANTY

Top

Spreadsheet::WriteExcel::FromDB::Query is free Open Source software. IT COMES WITHOUT WARRANTY OR SUPPORT OF ANY KIND.

SEE ALSO

Top

Spreadsheet::WriteExcel::FromDB. Spreadsheet::WriteExcel::Simple. Spreadsheet::WriteExcel. DBI

Spreadsheet-WriteExcel-FromDB-Query documentation Contained in the Spreadsheet-WriteExcel-FromDB-Query distribution. 
package Spreadsheet::WriteExcel::FromDB::Query;

$VERSION = '0.01';

use strict;
use warnings;

use Spreadsheet::WriteExcel::FromDB;

sub _croak { require Carp; Carp::croak(@_) }

# 2 functions are redefined.  Stop the warnings for redefine.
no warnings 'redefine';


# Redefine _data_query
undef &_data_query;
*Spreadsheet::WriteExcel::FromDB::_data_query = \&Spreadsheet::WriteExcel::FromDB::_data_query;

# Redefined _data_query function
sub Spreadsheet::WriteExcel::FromDB::_data_query {
  my $self   = shift;
  my $query = $self->table;
  return $query;
};


# Redefine _columns_in_table
undef &_data_query;
*Spreadsheet::WriteExcel::FromDB::_columns_in_table = \&Spreadsheet::WriteExcel::FromDB::_columns_in_table;

# Redefined _columns_in_table function
sub Spreadsheet::WriteExcel::FromDB::_columns_in_table {
  my $self = shift;
	my $query = $self->table;
	(my $sth = $self->dbh->prepare($query))->execute;
	my @cols = @{$sth->{NAME}};
	$sth->finish;
	return @cols;
}

1;



1;