Spreadsheet::Perl 0.07

Spreadsheet::Perl is a pure Perl implementation of a spreadsheet engine.

SYNOPSIS

use Spreadsheet::Perl;
use Spreadsheet::Perl::Arithmetic ;

my $ss = tie my %ss, "Spreadsheet::Perl"

$ss->SetNames("TEST_RANGE" => 'A5:B8') ;
$ss{TEST_RANGE} = '7' ;

DefineSpreadsheetFunction('AddOne', &AddOne) ;

$ss{A3} = PerlFormula('$ss->AddOne("A5") + $ss{A5}') ;
print "A3 formula => " . $ss->GetFormulaText('A3') . "n" ;
print "A3 = $ss{A3}n" ;

$ss{'ABC1:ABD5'} = '10' ;

$ss{A4} = PerlFormula('$ss->Sum("A5:B8", "ABC1:ABD5")') ;
print "A4 = $ss{A4}n" ;

...

Here are some key features of "Spreadsheet Perl":

· set and get values from cells or ranges
· handle cell private data
· has fetch/store callback
· has cell attributes access
· has cell/range fillers (auto-fill functionality)
· set formulas (pure perl and common format)
· compute the dependencies between cells
· formulas can fetch data from multiple spreadsheets and the dependencies still work
· checks for circular dependencies
· debugging triggers
· has a simple architecture for expansion
· has a simple architecture for debugging (and some flags are already implemented)
· can read its data from a file
· supports cell naming
· cell and range locking
· input validators
· cell formats (pod, HTML, ...)
· can define spreadsheet functions from the scripts using it or via a new module of your own
· Recalculate() / AUTOCALC
· value caching to speed up formulas and 'volatile' cells
· cell address offsetting functions
· Automatic formula offsetting
· Relative and fixed cell addresses
· slice access
· Perl scalar mapping to a cell
· some debugging tool (dump, dump table, dump to HTML, formula stack trace, ...)

Requirements:

· Perl



Product's homepage

Here are some key features of "Spreadsheet::Perl":

· set and get values from cells or ranges
· handle cell private data
· has fetch/store callback
· has cell attributes access
· has cell/range fillers (auto-fill functionality)
· set formulas (pure perl and common format)
· compute the dependencies between cells
· formulas can fetch data from multiple spreadsheets and the dependencies still work
· checks for circular dependencies
· debugging triggers
· has a simple architecture for expansion
· has a simple architecture for debugging (and some flags are already implemented)
· can read its data from a file
· supports cell naming
· cell and range locking
· input validators
· cell formats (pod, HTML, ...)
· can define spreadsheet functions from the scripts using it or via a new module of your own
· Recalculate() / AUTOCALC
· value caching to speed up formulas and 'volatile' cells
· cell address offsetting functions
· Automatic formula offsetting
· Relative and fixed cell addresses
· slice access
· Perl scalar mapping to a cell
· some debugging tool (dump, dump table, dump to HTML, formula stack trace, ...)

Requirements:

· Perl