views:

217

answers:

1

Is there any Javascript (or other NON-java ) CLIENT SIDE calculation library that will allow a complex excel spreadsheet to be posted online as a web page, and then can calculate directly on the web page when the user changes the values. Like a slimmed down web based excel.

I've seen JavaScript grid controls that offer simple calculation capabilities, but they do not allow you to import an existing sheet, or saving the sheet into an editable format for that matter.

I'm looking for a library (Client Side) that can read some sort of excel like file format (excel, wks, xml) , and interpret the cell references and formulas and then calculate on the web page, when the user changes a value.

The idea is to create a web page with the required form fields map those to the input cells on the sheet, and then map the results to the calculated values on the sheet.

+1  A: 

This is impossible to do solely on the client. You need to parse the XLS on the server then render the HTML and JS/JSON to the client. That's how e.g. Google Spreadsheets does it.

Matthew Flaschen
yeah i agree with matthew
Sam Rudolph