Querylet::Output::Excel::OLE - output query results to Excel via OLE
$Id: /my/cs/projects/q/excel/trunk/lib/Querylet/Output/Excel/OLE.pm 28050 2006-11-14T23:40:46.906717Z rjbs $
use Querylet::Output::Excel::OLE; use Querylet; database: bogosity query: SELECT detector_id, measurement FROM bogon_detections output format: excel
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.
This module isa Querylet::Output, and implements the interface described by that module.
The Excel::OLE handler is by default registered for the 'excel' type.
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.
If the "excel_workbook" and "excel_worksheet" options are set, it will attempt to open the named workbook file and put its results into the named worksheet, creating it if necessary. If the workbook, but not worksheet, is set, it will create a new worksheet in the named workbook.
If the "excel_postprocessing_callback" option is set, the handler will try to evaluate it into a code reference, the code reference will be called after all other processing is done. It will be passed a hash reference with the following keys:
query - the Querylet::Query object being output excel - the Excel.Application object workbook - the Workbook object worksheet - the Worksheet object
This converts a column number to a column name, Excel style. In other words:
1 -> A 26 -> Z 27 -> AA 2600 -> CUZ
Please report any bugs or feature requests to
firstname.lastname@example.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 2004-2006, 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.