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" ;
...
Main features:
- 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, ...)