OpenOffice::OOSheets - Perl module for quick access to spreadsheets cells by address and sheets by name.
use OpenOffice::OOSheets; ... my $zip = Archive::Zip->new($tmp_file_name); my $content=$zip->contents('content.xml'); ... my $res=OpenOffice::OOSheets::GetData (text=>$content,ref=> [ { 'cells' => [ 'Q46' ], 'table' => 'Sheet1' }, { 'cells' => [ 'B10' ], 'table' => 'Sheet2' } ]); ... print Dumper $res; ...
Perl module for quick access to spreadsheets cells by address and sheets by name.
OpenOffice::OOSheets::GetData - parse and return result
Parametrs :
( text=>$data, ref=>[ { table=>'sheet1', cells=>['B2','AA2','A1','E6','B4','C10','C11'] } ] )
Results:
{ 'Sheet1' => { 'Q46' => '21' } };
samples/README - for sample
Zahatski Aliaksandr, <zagap@users.sourceforge.net>
Copyright (C) 2004 by Zahatski Aliaksandr
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.2 or, at your option, any later version of Perl 5 you may have available.
2 POD Errors
The following errors were encountered while parsing the POD:
'=item' outside of any '=over'
You forgot a '=back' before '=head1'
To install OpenOffice::OOSheets, copy and paste the appropriate command in to your terminal.
cpanm
cpanm OpenOffice::OOSheets
CPAN shell
perl -MCPAN -e shell install OpenOffice::OOSheets
For more information on module installation, please visit the detailed CPAN module installation guide.