spreadsheet

Spreadsheet xlNavigator 2003 (Patent Pending), is the only tool that displays the relationships between spreadsheet cells in an highly intuitive manner. As a result, even the most complicated spreadsheet becomes simple and transparent to a user and undiscovered errors are caught early on. Figure 1 shows the visual representation provided by the xlNavigator.

Features:

· Navigate the spreadsheet using cell precedent-dependent representation.
· Flow chart representation emphasizes calculation order.
· Direct link between xlNavigator representation and Excel spreadsheet cells.
· Can use tracer arrows from the auditing toolbar in conjunction with the Spreadsheet xlNavigator

Spreadsheet::WriteExcelXML is a Perl module that can create an Excel file in XML format.

SYNOPSIS

To write a string, a formatted string, a number and a formula to the first worksheet in an Excel XML spreadsheet called perl.xls:

use Spreadsheet::WriteExcelXML;

# Create a new Excel workbook
my $workbook = Spreadsheet::WriteExcelXML->new("perl.xls");

# Add a worksheet
$worksheet = $workbook->add_worksheet();

# Add and define a format
$format = $workbook->add_format(); # Add a format
$format->set_bold();
$format->set_color(red);
$format->set_align(center);

# Write a formatted and unformatted string, row and column notation.
$col = $row = 0;
$worksheet->write($row, $col, "Hi Excel!", $format);
$worksheet->write(1, $col, "Hi Excel!");

# Write a number and a formula using A1 notation
$worksheet->write(A3, 1.2345);
$worksheet->write(A4, =SIN(PI()/4));

The Spreadsheet::WriteExcelXML module can be used to create an Excel file in XML format. The Excel XML format is supported in Excel 2002 and 2003.

Multiple worksheets can be added to a workbook and formatting can be applied to cells. Text, numbers, and formulas can be written to the cells. The module supports strings up to 32,767 characters and the strings can be in UTF8 format.

Spreadsheet::WriteExcelXML uses the same interface as Spreadsheet::WriteExcel.
This module cannot, as yet, be used to write to an existing Excel XML file.

Spreadsheet::ParseExcel is a Perl module to get information from an Excel file.

This module allows you to get information from Excel file.

This module can handle files of Excel95, 97 and 2000. (and now supports Excel4)

The module will work on the majority of Windows, UNIX and Macintosh platforms.

Spreadsheet::WriteExcel module is can be used to create native Excel binary files.

Formatted text and numbers can be written to multiple worksheets in a workbook. Formulas and functions are also supported. It is 100% Perl and doesnt require any Windows libraries or a copy of Excel.

It will also work on the majority of Unix and Macintosh platforms. Generated files are compatible with Excel 97, 2000, 2002, and 2003, and with OpenOffice and Gnumeric. An older version also supports Excel 5/95.

Spreadsheet::Read enables reading the data from a spreadsheet.

Spreadsheet::Read tries to transparantly read *any* spreadsheet and return its content in a universal manner independent of the parsing module that does the actual spreadsheet scanning.

For OpenOffice this module uses Spreadsheet::ReadSXC

For Excel this module uses Spreadsheet::ParseExcel

For CSV this module uses Text::CSV_XS

For SquirrelCalc there is a very simplistic built-in parser

PTab is a fully functional spreadsheet with the key features of common desktop spreadsheets: Excel & Pocket Excel comatibility, macros, charts, data validation, dropdown boxes, outline etc. It is a compact and powerfull app (one .exe file), it runs even on USB Memory Card!

PTab works on Windows NT/2000/XP (not on 95/98/ME).

PTab is available for Windows Desktop PC, Windows Mobile Pocket PC, Windows Mobile Smartphone, Windows CE.Net, Handheld PC (HPC) and Palm-Size PC.

Main PTab 3.0 features

-Export/Import - Microsoft Excel (.xls), Microsoft Pocket Excel (.pxl) files, TXT, CSV, DBF
-Charts
-Macros
-Data validation, dropdown boxes
-Group and outline
-External references (e.g. [BOOK.XLS]Sheet1!A5)


Other PTab 3.0 features

-256 sheets x 65536 rows x 256 columns
-249 built-in scientific, statistical, financial, date/time, logical, database, text and macro functions
-Multiple Undo/Redo
-Cut, Copy, Paste, Paste Special, Clear, Fill cells, Insert/Delete Rows/Columns
-Set row height and column width, hide/unhide rows and columns, autofit row heights and column widths.
-Insert function, Quick sum, Pointing
-Format: Number format, Alignment, Font, Size, Color, Background Color, Bold, Italic, Underline, Borders Protection
-Zoom
-Freeze Titles (row and column freezing)
-Formula bar or in place editing
-Sort, Go to cell, Find/Replace
-Names (define and insert)
-Protection
-Custom lists (e.g. Monday, Thursday, Wednesday...)
-Auto filter
-Insert sound or hyperlink (cell reference, Web page or E-mail address) in a cell
-Password protection
-Goal seek
-and more...

Simple Spreadsheet is a bare-bones spreadsheet available for free, including sources.

I wrote Simple Spreadsheet because I needed a spreadsheet with minimal features and just couldnt bring myself to spend hundreds of dollars buying one.

Simple Spreadsheet doesnt even do 10% of what the full-featured products do, but if you want only the basics, this spreadsheet is for you.

Simple Spreadsheet is a webbased spreadsheet program written in Javascript, HTML, CSS and PHP.

Simple Spreadsheet features formulas, charts, numeric formats, keyboard navigation, etc. Javascript is used for the default data format and for the macros and formulas.

Spreadsheet Consolidator is an Excel add-in which will allow to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easily and quickly.

Save yourself a lot of time and effort, right now, downloading free our trial software and testing it. You will get delighted!

Spreadsheet Consolidator is a n addin for excel that allows you consolidate spreadsheet data.

Spreadsheet Consolidator is a part of Model Assistant Suite (which will be released soon); wherefore, if you purchase this product you will obtain a special discounting for the rest of components.

Spreadsheet Consolidator description
Consolidate your Microsoft Excel spreadsheets flexible and quickly Spreadsheet Consolidator is an Excel add-in which will allow to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easily and quickly.

Save yourself a lot of time and effort, right now, downloading free our trial software and testing it. You will get delighted!

Spreadsheet Consolidator is an addin for excel that allows you consolidate spreadsheet data.

Spreadsheet Consolidator is a part of Model Assistant Suite (which will be released soon); wherefore, if you purchase this product you will obtain a special discounting for the rest of components.

Requirements: Microsoft Excel 2000 or more

Limitations:

· 15 days trial

Highlights errors that could easily be overlooked by adding graphical documentation to existing spreadsheets. These errors include inconsistent copies of formulas and year 2000 problems. It also clarifies the meaning of cryptic A1 references like = D34 - D35 by adding AutoNames which are based on cell labels, and it can compare differentversions of a spreadsheet.

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, ...)

Spreadsheet Composer is an Excel add-in, which offers significant productivity and development benefits. The core capability of the add-in is the compose function.

With this function it is possible to define a spreadsheet calculation as a series of linked steps and then automatically compose the calculation into a single complex formula. Spreadsheet Composer is a very powerful tool that enables the user to attain a level of functionality and error trapping that was previously difficult to achieve in a manageable spreadsheet.

The add-in provides a number of support features to facilitate the use and management of composed formulae. It provides a database for the storage; documentation and retrieval of formulae and a matching function that can link an implemented formula back to its database description.

The retrieval function allows the user to copy a formula from the database into a selected spreadsheet cell, to automatically select input cells for the formula and to specify a mix of relative and absolute addressing for the selected cells.

The add-in permits complete verification of a formula before it is stored within the database. The formula can be verified against its original definition and against its intended behaviour. If a formula gives an unintended output for a particular combination of inputs, then additional error trapping can be factored into the composed formula.

The add-in provides an export function, which allows a completed spreadsheet to be written out to a standalone workbook for independent operation.