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.