NAME

Querylet::Output::Excel::XLS - output querylet results to an Excel file

VERSION

version 0.10

$Id: XLS.pm,v 1.1.1.1 2004/09/21 20:07:28 rjbs Exp $

SYNOPSIS

use Querylet;
use Querylet::Output::Excel::XLS;

database: dbi:SQLite2:dbname=cpants.db

query:
  SELECT kwalitee.dist,kwalitee.kwalitee
  FROM   kwalitee
  JOIN   dist ON kwalitee.distid = dist.id
  WHERE  dist.author = 'RJBS'
  ORDER BY kwalitee.dist;

output format: xls
output file:   cpants.xls

DESCRIPTION

This module registers an output handler to produce excel files, using Spreadsheet::WriteExcel.

default_type

The default type for Querylet::Output::Excel::XLS is "xls"

handler

The output handler uses Spreadsheet::WriteExcel to produce an Excel "xls" file. You must use also set an output filename, or Spreadsheet::WriteExcel will die.

AUTHOR

Ricardo SIGNES, <rjbs@cpan.org>

BUGS

Please report any bugs or feature requests to bug-querylet-output-text@rt.cpan.org, or through the web interface at http://rt.cpan.org. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

COPYRIGHT

Copyright 2004 Ricardo SIGNES, All Rights Reserved.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.