A client of mine is looking to convert a critical 'application' based on multiple (very complex) spreadsheets into a web app. As part of this they'd like some of the web pages they use to enter/model data to resemble a spreadsheet as much as possible.
I'd be interested to know if anyone has any experience/recommendations for embeddable controls that could do this better than standard html/javascript/ajax code - although suggestions for Javascript frameworks that could do this are welcome too. I'm thinking mainly of ActiveX, Flex, Java or similar controls, commercial or open source are fine.
The coding languages to be used and platform is still open to debate, so ASP.NET against IE or PHP/Flex against Firefox, or some other combination is fine - this will be driven by the business requirement not the platform.
Functionality is of course the main driving force, but it's always useful to have nice looking eye candy so skinable and cool is a plus. With reference to Javascript frameworks I''ve previously used Dojo and Mootools, but I'd prefer something with a bit more snap.
Spreadsheet programs can transform data sets into various types of graphical displays. In Excel, the Charts section provides the ability to present a data set within a chart or graph. This allows users to visualize and communicate their data sets within presentations, for example using pie or bar charts.
Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based online interactive tables and spreadsheets compatible with other spreadsheet software. You can create an online spreadsheet table from a JS array, JSON, CSV or XSLX files.
The new XLOOKUP feature gives Excel users an easier, more flexible way to display information in their spreadsheets. The function is only available to Office 365 testers, and Microsoft will be make it more broadly available over time.
I'd say this comes down to data grids.
For Javascript frameworks: Jquery has 'plugins' like this. Serverside: Telerik has asp.net controls like this.
It really comes down to what platform mix you want to use.
Also, why do you want to bind an asp.net page to IE instead of Firefox?
For a web application, my recommendation would be a mix of asp.net mvc and jquery. JQuery is in my view the best and most stable JavaScript framework out there. The problem is that asp.net mvc is still in ctp phase and it's probably not 'supported' and 'stable' enough in some eyes. I already finished a mid-scale commercial web app based on the mixture and was pleased with it.
Check out ZK Spreadsheet its cool.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With