Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Spreadsheet-like control for a web application? [closed]

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.

like image 936
Cruachan Avatar asked Oct 15 '08 10:10

Cruachan


People also ask

How does a spreadsheet application improve the presentation of your data?

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.

What is Jspreadsheet?

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.

What is one new feature related to spreadsheets?

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.


2 Answers

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.

like image 109
kitsune Avatar answered Oct 13 '22 10:10

kitsune


Check out ZK Spreadsheet its cool.

like image 39
dhrubo Avatar answered Oct 13 '22 09:10

dhrubo