Zahatski Aliaksandr

NAME OpenOffice::OOSheets

OpenOffice::OOSheets - Perl module for quick access to spreadsheets cells by address and sheets by name.

SYNOPSIS

  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;
 
 ...

DESCRIPTION

Perl module for quick access to spreadsheets cells by address and sheets by name.

PUBLIC METHODS

  • 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'
                          }
          };

SEE ALSO

samples/README - for sample

AUTHOR

Zahatski Aliaksandr, <zagap@users.sourceforge.net>

COPYRIGHT AND LICENSE

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:

Around line 172:

'=item' outside of any '=over'

Around line 197:

You forgot a '=back' before '=head1'