SpreadJS has been used, and its function is very powerful. It basically realizes all the common functions of Excel, and it is also compatible with import and export Excel. IE supports more than 9, and common browsers such as chrome,firefox
I have used a control called handsontable, that has a certain excel function. I don't know if it meets your requirements.
example:
https://handsontable.com/exam.
using SpreadJS, should meet your needs.
SpreadJS is a pure front-end spreadsheet control based on HTML5, featuring" high speed and low consumption, highly similar to Excel, and infinitely expandable ", providing mobile cross-platform and browser support. At the same time, it meets the business scenarios such as Web Excel component development, data filling, online documents, chart and formula linkage, Excel UI-like design and other business scenarios in .NET, Java, App and other applications, bringing you a cordial Excel experience. SpreadJS does not need a lot of code development and testing in data visualization, Excel import and export, formula reference, data binding, framework integration and other scenarios, which greatly reduces the enterprise R & D cost and project delivery risk.
you can try Smart Table (ZCELL) . In fact, I also used Huabiao, but later I switched to BS, and I didn't find a substitute, so I used this. Compatibility is still good, can be compatible with IE8, but the function is relatively simple, do not know whether to meet your needs.