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.