The Objectsheet: Home

The Objectsheet A casual, object-oriented data analysis tool

Function Reference

Notes and Links

email developer

The Objectsheet is a spreadsheet-like tool that uses Javascript for data, formulas, and code.

Instead of an A1/B2 cartesian grid, the Objectsheet organizes rows of cells into Javascript objects.

Objectsheet formulas, formats, styles, event handlers, etc. are organized into a "Template" within each Table.

The Objectsheet application is fully contained in a single HTML file and works with most major browsers.

Read more...

Why? By replacing the large cartesian grid with resizable object-oriented tables, the Objectsheet makes working with data-oriented models easy, safe, and manageable by:

Making it easy to see how a given model works	"Templates" within tables organize formulas and formats Data, formulas, formats, and code can all be viewed at once Easily assign meaningful names to tables, rows, columns, and cells in formulas
Avoiding common errors when developing a model	Automatically highlights manually entered cell values/formulas Formulas apply over an entire column or table without replication Self-contained tables can be moved around and formatted independent of each other; not bound by a single large grid
Helping guard against errors or model damage by users	Simple but powerful mechanisms to detect or prevent entry of improper data The ability to lock Templates, preventing changes to a model's rules If a user overrides a cell's formula with data, the formula returns if the data is later erased.
Easy to integrate and interact with other applications	Open JSON file format allows other applications to easily read Objectsheet files. Easily interact with external data sources (e.g., XML, JSON) from within the Objectsheet.

Read more...

Learn and Try via a set of live on-line tutorials.

Examples See screenshots and experiment with sample Objectsheet applications online.

Download The Objectsheet is available in several forms for download, under the BSD license