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

Spreadsheet::Perl Ranking & Summary

Spreadsheet::Perl Tags

spreadsheet engine Perl module Perl implementation spreadsheet engine

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