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.

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.