NAME

Querylet::Output::Excel::OLE - output query results to Excel via OLE

VERSION

version 0.10

 $Id: OLE.pm,v 1.2 2004/09/21 12:34:09 rjbs Exp $

SYNOPSIS

 use Querylet::Output::Excel::OLE;
 use Querylet;

 database: bogosity

 query:
   SELECT detector_id, measurement
   FROM   bogon_detections

 output format: excel

DESCRIPTION

Querylet::Output::Excel::OLE provides an output handler for Querylet that will create a new instance of Microsoft Excel using Win32::OLE and populate a worksheet with the query results.

METHODS

This module isa Querylet::Output, and implements the interface described by that module.

default_type

The Excel::OLE handler is by default registered for the 'excel' type.

handler

The Querylet::Output::Excel::OLE handler returns a coderef that, when called, will create an Excel.Application object, then create a workbook, and then populate its worksheet with the querylet's results.

FUNCTIONS

column_name($column_number)

This converts a column number to a column name, Excel style. In other words:

    1 -> A
   26 -> Z
   27 -> AA
 2600 -> CUZ

AUTHOR

Ricardo SIGNES, <rjbs@cpan.org>

BUGS

Please report any bugs or feature requests to bug-querylet-output-excelapp@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.