Re: RFC: Yet Another Excel Writer..
I think ::Simple is probably the most standard way of doing that. I'm not aware of any ::Easy modules. Perhaps ::Simple is a much better offer. :)
Re: RFC: Yet Another Excel Writer..
On Wed, Apr 08, 2009 at 02:58:43PM -0700, Bill Ward wrote: I think ::Simple is probably the most standard way of doing that. I'm not aware of any ::Easy modules. FWIW, ... mysql select distinct module from modules where module like '%::Easy'; +-+ | module | +-+ | Algorithm::Evolutionary::Op::Easy | | Authen::Krb5::Easy | | Bone::Easy | | Class::Easy | | Config::Easy| | Curl::easy | | Daemon::Easy| | Date::DateTime::Easy| | DateTime::Easy | | DateTimeX::Easy | | DBI::Easy | | DBIx::Easy | | Egg::Plugin::BackUP::Easy | | Egg::Plugin::DBI::Easy | | Exporter::Easy | | Frontier::Client::Easy | | Getopt::Easy| | Graph::Easy | | IO::Easy| | IO::Pty::Easy | | Lingua::EN::Numbers::Easy | | Log::Easy | | Logic::Easy | | Mail::Summary::Tools::ArchiveLink::Easy | | MLDBM::Easy | | MooseX::Log::Log4perl::Easy | | MySQL::Easy | | Net::Pcap::Easy | | Penguin::Easy | | Project::Easy | | RDF::AllegroGraph::Easy | | Test::Easy | | Text::Editor::Easy | | Tie::Hash::Easy | | Tie::IxHash::Easy | | Tie::Scalar::Easy | | TM::Easy| | Win32::GUIRobot::Easy | | WWW::Curl::Easy | | XML::Easy | | XML::LibXSLT::Easy | +-+ 41 rows in set (9.89 sec) -- David Cantrell | Hero of the Information Age Irregular English: ladies glow; gentlemen perspire; brutes, oafs and athletes sweat
Re: RFC: Yet Another Excel Writer..
On Wed, Apr 1, 2009 at 1:36 AM, sawyer x xsawy...@gmail.com wrote: Sounds like a good module to me. I know I could have used it a few weeks ago. If so, is this set of modules aptly named? - Does it use a standard CPAN module for email sending? - What does it use for formating to web? If it's a subset of Spreadsheet::WriteExcel, maybe it would be better off to note it as Spreadsheet::WriteExcel::Easy or whatever. Basically a name that says oh wait, it's a subset of Spreadsheet::WriteExcel that will make it easier/faster (to write)/use better defaults for me than the basic Spreadsheet::WriteExcel. I think ::Simple is probably the most standard way of doing that. I'm not aware of any ::Easy modules.
Re: RFC: Yet Another Excel Writer..
On Mon, 30 Mar 2009 16:21:10 -0500
Brad Lhotsky b...@divisionbyzero.net wrote:
# Add a new format
$report-addFormat('credit', { color='green', bold = 1 } );
# Use that:
$report-custom_row( 'credit', 1, '2009-04-01', 2000.00, 0, 'Bank Error');
A small note on API - you seem inconsistent here between camelCase and
under_scores. Pick one. I suggest the latter - it seems more the way perl
is done by convention.
--
Paul LeoNerd Evans
leon...@leonerd.org.uk
ICQ# 4135350 | Registered Linux# 179460
http://www.leonerd.org.uk/
signature.asc
Description: PGP signature
Re: RFC: Yet Another Excel Writer..
Sounds like a good module to me. I know I could have used it a few weeks ago. If so, is this set of modules aptly named? - Does it use a standard CPAN module for email sending? - What does it use for formating to web? If it's a subset of Spreadsheet::WriteExcel, maybe it would be better off to note it as Spreadsheet::WriteExcel::Easy or whatever. Basically a name that says oh wait, it's a subset of Spreadsheet::WriteExcel that will make it easier/faster (to write)/use better defaults for me than the basic Spreadsheet::WriteExcel. Other than that, the email sending and formating for web sound like really interesting addons. I'm interested in how they are implemented and whether they can be done strictly as subsets that have that added behavior. That is, Spreadsheet::WriteExcel::CGI, or Spreadsheet::WriteExcel::Email. The Spreadsheet CGI one would definitely be an interesting Catalyst/Jifty plugin/view. Just my two cents (or less). Sawyer.
RFC: Yet Another Excel Writer..
I created a module that I've been using happily in house for generating
quick reports. It does a few things automatically and simplifies the
Spreadsheet::WriteExcel interface.
* Automatic Cell Width Adjustment based on text width
* Borders around all the data
Example:
my $report = Spreadsheet::Report::Basic-new({
title = 'My Simple Report',
filename = 'mysimple.xls',
alignment = 'portrait',
});
# Setup the Column Headers
$report-columnHeaders(
'ID',
'Date',
'Credit',
'Debt',
'Category'
);
# Add Data
$report-addRow(1, '2009-03-30', 0, 20.00, 'Grocery');
# Add a new format
$report-addFormat('credit', { color='green', bold = 1 } );
# Use that:
$report-custom_row( 'credit', 1, '2009-04-01', 2000.00, 0, 'Bank Error');
# Insert a blank row:
$report-blank_row();
The really neat part of the interface is the handling of the
reporting.
If you want to save it:
$report-WriteToFile( '/tmp' );
If you want to Email it:
$report-EmailReport({
to = 'm...@domain.com',
cc = [ qw(someonec...@domain.com anotherper...@domain.com) ]
});
If you want to incorporate it into a website, and the person is
downloading the report:
my $c = new CGI;
$report-OutputToBrowser( $c );
There's also a multisheet capable version named
Spreadsheet::Report::Multi.
My question is, do you think the CPAN needs another spreadsheet module?
If so, is this set of modules aptly named?
--
Brad Lhotsky
Re: RFC: Yet Another Excel Writer..
On Mar 30, 2009, at 4:21 PM, Brad Lhotsky wrote: My question is, do you think the CPAN needs another spreadsheet module? Doesn't matter whether it does or not. Your real question is Should I upload my module to CPAN? and the answer is Absolutely, yes. There is no reason NOT to upload it, and your module may be far-and- away better than all the others, for some value of better, for some population. Or it might be a steaming pile of crap, and nobody ever uses it. Or a little of both, depending. But that's how open source works! xoxo, Andy -- Andy Lester = a...@petdance.com = www.petdance.com = AIM:petdance
