[Catalyst] View plugin for excell/OO

Angel Kolev ankolev at gmail.com
Mon Jan 14 14:01:31 GMT 2008


Peter Karman wrote:
>
>
> Angel Kolev wrote on 1/14/08 6:50 AM:
>> Jens Gassmann wrote:
>>> Hi Angel,
>>>
>>> > Is there any catalyst 'View' plugin for excel/open office sheets?
>>>
>>> http://search.cpan.org/~stevan/Catalyst-View-Excel-Template-Plus-0.01/lib/Catalyst/View/Excel/Template/Plus.pm 
>>>
>>>
>>> jens
>>>
>> I want to export SQL with DBIx::Class to excel sheet, but 
>> Catalyst-View-Excel-Template-Plus is not enough documented. Can 
>> anyone show me examples pls.
>> Thanks.
>>
>
> Look at CatalystX::CRUD::View::Excel.
>
> http://search.cpan.org/~karman/CatalystX-CRUD-View-Excel-0.03/
>
It blows empty file. I cant found where is my fault:

package MyApp::View::Excel;
use strict;
use base 'CatalystX::CRUD::View::Excel';

 __PACKAGE__->config(
    TEMPLATE_EXTENSION => 'tt',
    etp_config => {
        INCLUDE => [ 'root/src/sheets' ],
}
 );
 
1;


In MyApp::Archives:

sub export : Local {
    my ($self, $c) = @_;
    $c->stash->{worksheet_name} = 'My Archive';
    $c->stash->{template}='archive_export';
        $c->stash->{current_view} = 'Excel';
            
}

the file archive_report.tt is in MyApp/root/src/sheets
xls that i receive is named myapp_archives_export.xls

Help pls





More information about the Catalyst mailing list