Javascript calculation library (Excel like web page without the grid) [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

开发者_开发百科

Closed 5 years ago.

Improve this question

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.

---

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.

---

Im actually working on a project that has some relevance here. Its an ongoing work on assignment from my employer.

They are using mediawiki, and want to have the ability to upload excel files to be displayed and client-side edited. My solution is to use PHPExcel for the initial grunt work of reading the excel file, then converting the data im interested in and passing it as json to my own js library that handles formula parsing and evaluation.

https://github.com/netbrain/spreadsheet-js

Feel free to contribute any missing excel functions :-)