Spreadsheet::PerlSpreadsheet::Perl is a pure Perl implementation of a spreadsheet engine. | |
Download |
Spreadsheet::Perl Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Khemir Nadim ibn Hamouda
- Publisher web site:
- http://search.cpan.org/~nkh/PerlBuildSystem-0.44/PBS/Digest.pm
Spreadsheet::Perl Tags
Spreadsheet::Perl Description
Spreadsheet::Perl is a pure Perl implementation of a spreadsheet engine. 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 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
Spreadsheet::Perl Related Software