AlignDB-ToXLSX

 view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN


1.1.3  2016-01-22 21:34:04 CST
    - y_last_column in draw_y()
    - better _find_scale()

1.1.2  2016-01-22 03:48:56 CST
    - major_tick_mark => 'inside'
    - $opt->{cross} for draw_y()

1.1.1  2016-01-22 02:52:14 CST
    - Record worksheet cursor in object, row() and column()
    - s/option/opt/g
    - Remove write_content_*(). May add later.

1.1.0  2016-01-22 01:12:21 CST
    - Remove hard dependency on DBD::mysql
    - write_header_direct() ==> write_header()
    - Remove write_header_sql(), use sql2names()
    - write_row_direct() ==> write_row()
    - write_content_direct() ==> write_sql()

lib/AlignDB/ToXLSX.pm  view on Meta::CPAN

our $VERSION = '1.2.1';

# Mysql dbh
has dbh => ( is => 'ro', isa => 'Object' );

# outfiles
has outfile  => ( is => 'ro', isa => 'Str' );        # output file, autogenerable
has workbook => ( is => 'ro', isa => 'Object' );     # excel workbook object
has format   => ( is => 'ro', isa => 'HashRef' );    # excel formats

# worksheet cursor
has row    => ( is => 'rw', isa => 'Num', default => sub {0}, );
has column => ( is => 'rw', isa => 'Num', default => sub {0}, );

# charts
has font_name => ( is => 'rw', isa => 'Str', default => sub {'Arial'}, );
has font_size => ( is => 'rw', isa => 'Num', default => sub {10}, );
has width     => ( is => 'rw', isa => 'Num', default => sub {320}, );
has height    => ( is => 'rw', isa => 'Num', default => sub {320}, );
has max_ticks => ( is => 'rw', isa => 'Int', default => sub {6} );



( run in 0.239 second using v1.01-cache-2.11-cpan-4d50c553e7e )