Browse and search CPAN

Modules > > S > > Spreadsheet

Spreadsheet::BasicRead Methods to easily read data from spreadsheets	Spreadsheet::BasicReadNamedCol Methods to easily read data from spreadsheets with columns in the order you want based on the names of the column headings	Spreadsheet::ConvertAA Perl extension for Converting Spreadsheet column name to/from decimal
Spreadsheet::DataFromExcel read a sheet from Excel file into a simple arrayref of arrayrefs	Spreadsheet::DataToExcel Simple method to generate Excel files from 2D arrayrefs	Spreadsheet::Engine Core calculation engine for a spreadsheet
Spreadsheet::Engine::Error Standard errors	Spreadsheet::Engine::Fn::Approximator Solve using Newton's method	Spreadsheet::Engine::Fn::base base class for spreadsheet functions
Spreadsheet::Engine::Fn::counter base class for counting functions	Spreadsheet::Engine::Fn::depreciation base class for depreciation functions	Spreadsheet::Engine::Fn::hms base class for HMS functions
Spreadsheet::Engine::Fn::investment base class for investment functions	Spreadsheet::Engine::Fn::logical base class for logical functions	Spreadsheet::Engine::Fn::math base class for math functions
Spreadsheet::Engine::Fn::math2 base class for 2arg math functions	Spreadsheet::Engine::Fn::Operand An operand passed to a function	Spreadsheet::Engine::Fn::series base class for series functions
Spreadsheet::Engine::Fn::text base class for text functions	Spreadsheet::Engine::Fn::ymd base class for DMY functions	Spreadsheet::Engine::Function::ABS Spreadsheet funtion ABS()
Spreadsheet::Engine::Function::ACOS Spreadsheet funtion ACOS()	Spreadsheet::Engine::Function::AND Spreadsheet funtion AND()	Spreadsheet::Engine::Function::ASIN Spreadsheet funtion ASIN()
Spreadsheet::Engine::Function::ATAN Spreadsheet funtion ATAN()	Spreadsheet::Engine::Function::ATAN2 Spreadsheet funtion ATAN2()	Spreadsheet::Engine::Function::AVERAGE Spreadsheet funtion AVERAGE()
Spreadsheet::Engine::Function::CHOOSE Spreadsheet funtion CHOOSE()	Spreadsheet::Engine::Function::COS Spreadsheet funtion COS()	Spreadsheet::Engine::Function::COUNT Spreadsheet funtion COUNT()
Spreadsheet::Engine::Function::COUNTA Spreadsheet funtion COUNTA()	Spreadsheet::Engine::Function::COUNTBLANK Spreadsheet funtion COUNTBLANK()	Spreadsheet::Engine::Function::DATE Spreadsheet funtion DATE()
Spreadsheet::Engine::Function::DAY Spreadsheet funtion DAY()	Spreadsheet::Engine::Function::DDB Spreadsheet funtion DDB()	Spreadsheet::Engine::Function::DEGREES Spreadsheet funtion DEGREES()
Spreadsheet::Engine::Function::ERRCELL Spreadsheet funtion ERRCELL()	Spreadsheet::Engine::Function::EVEN Spreadsheet funtion EVEN()	Spreadsheet::Engine::Function::EXACT Spreadsheet funtion EXACT()
Spreadsheet::Engine::Function::EXP Spreadsheet funtion EXP()	Spreadsheet::Engine::Function::FACT Spreadsheet funtion FACT()	Spreadsheet::Engine::Function::FALSE Spreadsheet funtion FALSE()
Spreadsheet::Engine::Function::FIND Spreadsheet funtion FIND()	Spreadsheet::Engine::Function::FV Spreadsheet funtion FV()	Spreadsheet::Engine::Function::HLOOKUP Spreadsheet funtion HLOOKUP()
Spreadsheet::Engine::Function::HOUR Spreadsheet funtion HOUR()	Spreadsheet::Engine::Function::IF Spreadsheet funtion IF()	Spreadsheet::Engine::Function::INT Spreadsheet funtion INT()
Spreadsheet::Engine::Function::IRR Spreadsheet funtion IRR()	Spreadsheet::Engine::Function::ISBLANK Spreadsheet funtion ISBLANK()	Spreadsheet::Engine::Function::ISERR Spreadsheet funtion ISERR()
Spreadsheet::Engine::Function::ISERROR Spreadsheet funtion ISERROR()	Spreadsheet::Engine::Function::ISLOGICAL Spreadsheet funtion ISLOGICAL()	Spreadsheet::Engine::Function::ISNA Spreadsheet funtion ISNA()
Spreadsheet::Engine::Function::ISNONTEXT Spreadsheet funtion ISNONTEXT()	Spreadsheet::Engine::Function::ISNUMBER Spreadsheet funtion ISNUMBER()	Spreadsheet::Engine::Function::ISTEXT Spreadsheet funtion ISTEXT()
Spreadsheet::Engine::Function::LEFT Spreadsheet funtion LEFT()	Spreadsheet::Engine::Function::LEN Spreadsheet funtion LEN()	Spreadsheet::Engine::Function::LN Spreadsheet funtion LN()
Spreadsheet::Engine::Function::LOG Spreadsheet funtion LOG()	Spreadsheet::Engine::Function::LOG10 Spreadsheet funtion LOG10()	Spreadsheet::Engine::Function::LOWER Spreadsheet funtion LOWER()
Spreadsheet::Engine::Function::MATCH Spreadsheet funtion MATCH()	Spreadsheet::Engine::Function::MAX Spreadsheet funtion MAX()	Spreadsheet::Engine::Function::MID Spreadsheet funtion MID()
Spreadsheet::Engine::Function::MIN Spreadsheet funtion MIN()	Spreadsheet::Engine::Function::MINUTE Spreadsheet funtion MINUTE()	Spreadsheet::Engine::Function::MOD Spreadsheet funtion MOD()
Spreadsheet::Engine::Function::MONTH Spreadsheet funtion MONTH()	Spreadsheet::Engine::Function::N Spreadsheet funtion N()	Spreadsheet::Engine::Function::NA Spreadsheet funtion NA()
Spreadsheet::Engine::Function::NOT Spreadsheet funtion NOT()	Spreadsheet::Engine::Function::NOW Spreadsheet funtion NOW()	Spreadsheet::Engine::Function::NPER Spreadsheet funtion NPER()
Spreadsheet::Engine::Function::NPV Spreadsheet funtion NPV()	Spreadsheet::Engine::Function::ODD Spreadsheet funtion ODD()	Spreadsheet::Engine::Function::OR Spreadsheet funtion OR()
Spreadsheet::Engine::Function::PI Spreadsheet funtion PI()	Spreadsheet::Engine::Function::PMT Spreadsheet funtion PMT()	Spreadsheet::Engine::Function::POWER Spreadsheet funtion POWER()
Spreadsheet::Engine::Function::PRODUCT Spreadsheet funtion PRODUCT()	Spreadsheet::Engine::Function::PROPER Spreadsheet funtion PROPER()	Spreadsheet::Engine::Function::PV Spreadsheet funtion PV()
Spreadsheet::Engine::Function::RADIANS Spreadsheet funtion RADIANS()	Spreadsheet::Engine::Function::RATE Spreadsheet funtion RATE()	Spreadsheet::Engine::Function::REPLACE Spreadsheet funtion REPLACE()
Spreadsheet::Engine::Function::REPT Spreadsheet funtion REPT()	Spreadsheet::Engine::Function::RIGHT Spreadsheet funtion RIGHT()	Spreadsheet::Engine::Function::ROUND Spreadsheet funtion ROUND()
Spreadsheet::Engine::Function::SECOND Spreadsheet funtion SECOND()	Spreadsheet::Engine::Function::SIN Spreadsheet funtion SIN()	Spreadsheet::Engine::Function::SLN Spreadsheet funtion SLN()
Spreadsheet::Engine::Function::SQRT Spreadsheet funtion SQRT()	Spreadsheet::Engine::Function::STDEV Spreadsheet funtion STDEV()	Spreadsheet::Engine::Function::STDEVP Spreadsheet funtion STDEVP()
Spreadsheet::Engine::Function::SUBSTITUTE Spreadsheet funtion SUBSTITUTE()	Spreadsheet::Engine::Function::SUM Spreadsheet funtion SUM()	Spreadsheet::Engine::Function::SYD Spreadsheet funtion SYD()
Spreadsheet::Engine::Function::T Spreadsheet funtion T()	Spreadsheet::Engine::Function::TAN Spreadsheet funtion TAN()	Spreadsheet::Engine::Function::TIME Spreadsheet funtion TIME()
Spreadsheet::Engine::Function::TODAY Spreadsheet funtion TODAY()	Spreadsheet::Engine::Function::TRIM Spreadsheet funtion TRIM()	Spreadsheet::Engine::Function::TRUE Spreadsheet funtion TRUE()
Spreadsheet::Engine::Function::TRUNC Spreadsheet funtion TRUNC()	Spreadsheet::Engine::Function::UPPER Spreadsheet funtion UPPER()	Spreadsheet::Engine::Function::VALUE Spreadsheet funtion VALUE()
Spreadsheet::Engine::Function::VAR Spreadsheet funtion VAR()	Spreadsheet::Engine::Function::VARP Spreadsheet funtion VARP()	Spreadsheet::Engine::Function::VLOOKUP Spreadsheet funtion VLOOKUP()
Spreadsheet::Engine::Function::WEEKDAY Spreadsheet funtion WEEKDAY()	Spreadsheet::Engine::Function::YEAR Spreadsheet funtion YEAR()	Spreadsheet::Engine::Functions Spreadsheet functions (SUM, MAX, etc)
Spreadsheet::Engine::Sheet Spreadsheet basics	Spreadsheet::Engine::Storage::SocialCalc load SocialCalc files	Spreadsheet::Engine::Value A value/type combination
Spreadsheet::Excel2Text	Spreadsheet::ExcelHashTable Converts Excel Table to Perl Hash and vicerversa	Spreadsheet::ParseExcel Get information from Excel file
Spreadsheet::ParseExcel::Cell A class for Cell data and formatting.	Spreadsheet::ParseExcel::Dump A class for dumping Excel records.	Spreadsheet::ParseExcel::FmtDefault A class for Cell formats.
Spreadsheet::ParseExcel::FmtJapan A class for Cell formats.	Spreadsheet::ParseExcel::FmtJapan2 A class for Cell formats.	Spreadsheet::ParseExcel::FmtUnicode A class for Cell formats.
Spreadsheet::ParseExcel::Font A class for Cell fonts.	Spreadsheet::ParseExcel::Format A class for Cell formats.	Spreadsheet::ParseExcel::SaveParser Rewrite an existing Excel file.
Spreadsheet::ParseExcel::SaveParser::Workbook A class for SaveParser Workbooks.	Spreadsheet::ParseExcel::SaveParser::Worksheet A class for SaveParser Worksheets.	Spreadsheet::ParseExcel::Simple A simple interface to Excel data
Spreadsheet::ParseExcel::Utility Utility functions for Spreadsheet::ParseExcel.	Spreadsheet::ParseExcel::Workbook A class for Workbooks.	Spreadsheet::ParseExcel::Worksheet A class for Worksheets.
Spreadsheet::ParseExcel_XLHTML Parse Excel Spreadsheets using xlhtml	Spreadsheet::Perl Pure Perl implementation of a spreadsheet engine	Spreadsheet::Perl::Arithmetic Arithmetic functions for Spreadsheet::Perl
Spreadsheet::PrintExcelSheet	Spreadsheet::Read Transparent read the data from a spreadsheet	Spreadsheet::ReadSXC Extract OpenOffice 1.x spreadsheet data
Spreadsheet::SimpleExcel Create Excel files with Perl	Spreadsheet::TieExcel Perl extension for tie'ing Excel spreadsheets.	Spreadsheet::Wright simple spreadsheet worker
Spreadsheet::Wright::CSV	Spreadsheet::Wright::Excel	Spreadsheet::Wright::HTML
Spreadsheet::Wright::JSON	Spreadsheet::Wright::OpenDocument	Spreadsheet::Wright::OpenDocumentXML
Spreadsheet::Wright::XHTML	Spreadsheet::Write::CSV	Spreadsheet::Write::Excel
Spreadsheet::Write::HTML	Spreadsheet::Write::OpenDocument	Spreadsheet::Write::OpenDocumentXML
Spreadsheet::Write::XHTML	Spreadsheet::WriteExcel Write cross-platform Excel binary file.	Spreadsheet::WriteExcel::BIFFwriter
Spreadsheet::WriteExcel::Big	Spreadsheet::WriteExcel::Chart	Spreadsheet::WriteExcel::Chart::Area
Spreadsheet::WriteExcel::Chart::Bar	Spreadsheet::WriteExcel::Chart::Column	Spreadsheet::WriteExcel::Chart::External
Spreadsheet::WriteExcel::Chart::Line	Spreadsheet::WriteExcel::Chart::Pie	Spreadsheet::WriteExcel::Chart::Scatter
Spreadsheet::WriteExcel::Chart::Stock	Spreadsheet::WriteExcel::Examples	Spreadsheet::WriteExcel::Format
Spreadsheet::WriteExcel::Formula	Spreadsheet::WriteExcel::FromDB Convert a database table to an Excel spreadsheet	Spreadsheet::WriteExcel::FromDB::Query Convert a database query to an Excel spreadsheet
Spreadsheet::WriteExcel::FromXML Create Excel Spreadsheet from XML	Spreadsheet::WriteExcel::FromXML::Workbook	Spreadsheet::WriteExcel::FromXML::Worksheet
Spreadsheet::WriteExcel::OLEwriter	Spreadsheet::WriteExcel::Properties	Spreadsheet::WriteExcel::Simple A simple single-sheet Excel document
Spreadsheet::WriteExcel::Simple::Save convenience method for Spreadsheet::WriteExcel::Simple	Spreadsheet::WriteExcel::Simple::Tabs Simple Interface to the Spreadsheet::WriteExcel Package	Spreadsheet::WriteExcel::Styler Styles for formatting Spreadsheet::WriteExcel
Spreadsheet::WriteExcel::Utility	Spreadsheet::WriteExcel::Workbook	Spreadsheet::WriteExcel::Worksheet
Spreadsheet::WriteExcel::Worksheet::SheetProtection Sheet Protection for SWE	Spreadsheet::WriteExcelXML Create an Excel file in XML format.	Spreadsheet::WriteExcelXML::Format
Spreadsheet::WriteExcelXML::Utility	Spreadsheet::WriteExcelXML::Workbook	Spreadsheet::WriteExcelXML::Worksheet
Spreadsheet::WriteExcelXML::XMLwriter	Spreadsheet::XlateExcel Trigger a callback subroutine on each row of an Excel spreadsheet	Spreadsheet::XLSX Perl extension for reading MS Excel 2007 files;
Spreadsheet::XLSX::Fmt2007	Spreadsheet::XLSX::Utility2007 Utility function for Spreadsheet::XLSX

Problems, suggestions, or comments to Randy Kobes.		Questions? Check the FAQ.
		Enable installations using PAR::WebStart.