jQuery.sheet gives you all sorts of possibilities when it comes to giving your web application a spreadsheet style interface with MS Excel style calculations.

jQuery.sheet manages the sheet creation, viewing, and editing processes.  It can even be used like a datagrid, without calculations.
For a complete list of all the MS Excel style functions that jQuery.sheet supports, take a look at the Demo, which is the documentation.

Why did I start jQuery.sheet?  I like a challenge, I like to learn, I like to contribute, and I saw where other attempts at the same thing, although being nice, could be improved and I wanted to put some fun back into my javascript.

jQuery.sheet is cool, here's why:

• Multi-sheets (create new right from the ui)
• 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
• In-line Controls (select list, radio buttons, checkboxes)
• Charts (jGCharts)
  
• Themeable (jQuery UI ThemeRoller)
• Based on html tables
• Fully AJAX ready
  

(for more, check out the demo, which actually is the documentation)

Basic initialization:
$(function() {
    $(jQuerySelector).sheet();
});

Make a new sheet (10 Columns by 30 Rows):
$(function() {
    $(jQuerySelector).sheet({
        buildSheet: '10x30' //will also accept table object(s)
    });
});

Turn jQuerySelector child table into a sheet:
$(function() {
    $(jQuerySelector).sheet({
        buildSheet: true
    });
});

Open a sheet for edit & set it's save location:
$(function() {
    $(jQuerySelector).sheet({
        urlGet: "Address_of_my_sheet.html",
        urlSave: "Address_of_my_sheet_savepage.php"
    });
});

Open a sheet for viewing only, like a gridview:
$(function() {
    $(jQuerySelector).sheet({
        urlGet: "Address_of_my_sheet.html",
        editable: false
    });
});

Open a sheet for editing, but all functions are locked:
$(function() {
    $(jQuerySelector).sheet({
        urlGet: "Address_of_my_sheet.html",
        lockFormulas: true
    });
});

The list is short at this time, but it is growing!

• Visual Interop Development
• TikiWiki
• OwnAlbum.com
• Primefaces.org
  
• You? (Let Us Know Below)