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.