jQuery.sheet

The interface and functionality is cloned from Microsoft's Office Excel tool.

It tries to implement as many features as possible, using only jQuery code.

Features:

• Based on HTML tables
• Fully AJAX ready
• Multi-sheets
• Multi instance
• Cross-sheet calculations
• Re-sizable (columns, rows, sheet)
• Fast calculations engine
• Selectable rows and columns
• Shifting formulas (when insert or delete it updates surrounding formulas)
• Cross-browser compatibility
• Easy for developers to integrate
• Easy for users to learn
• XML / JSON / HTML export/import
• Inline controls (select list, radio buttons, checkboxes)
• Charts
• Themeable (jQuery UI ThemeRoller)

What is new in this release:

• Updated links and jQuery JSON file.

What is new in version 3.0:

• Freezable cells
• Merge-able cells
• Supports multi line breaks on and off
• Cell styles
• Undo & redo
• Open API for easy customizations
• Multi-sheets (create new right from the UI)
• Multi instance
• Cross-sheet calculations (examples: TABLE2!A1 , TABLE2!A1:B4)
• Re-sizable (columns, rows, sheet)

What is new in version 2.0.0-rc2:

• Migrated nearly all the events over to jQuery event types, called on the parent object.

What is new in version 2.0.0-rc-1:

• Better Undo/Redo.
• Contextual (right click) menus.
• New, completely secure, calculations engine with easy to create functions for use inside cells.
• Actual formula language parsing, not JavaScript.
• Intuitive object reference inside formula function (this.sheet, this.row, this.col, this.cell, this.s, this.editable, this.jS).
• Alpha php SERVER SIDE language parser.
• Better migration over to jQuery UI (Resize, sort tabs, etc).
• Sortable tabs.
• Much better use of jQuery custom events/triggers.
• Cell values update on insert and remove of cells.
• Much faster than the original.

Requirements:

• JavaScript enabled on client side
• jQuery
• jQuery UI