2

I have an excel file with data and need to make this available on web. The web version of the excel file need to have the following features

  • Switch between read and edit mode
  • All cells should be editable at the same time
  • Inline editing of each cell
  • Save all cells that have been changed with a single button.
  • Ability to add and remove rows
  • Store values in notes document(s)

I have looked at the Dojo Grid JSON REST control in the extension library sample database and it does basically all that I want but I am not happy with the presentation and it seem a bit limited as I later on may need to add other actions to the table cells.

I am looking for an html table version

Which controls should I use to accomplish this? and how can I create a submit button that saves all cells/rows?

Thanks for helping out

Thomas

Thomas Adrian
  • 3,543
  • 6
  • 32
  • 62

2 Answers2

3

There is also a project on OpenNTF that gives you a full fledged spreadsheet, that can even load Excel files. It is based on the OpenSource ZK-Spreadsheet

Have a look!

The OpenNTF project was one of the winners in the first OpenNTF contest.

stwissel
  • 20,110
  • 6
  • 54
  • 101
2

All of those options are possible with the EXTJS grid

You can see some examples here

http://demo.xomino.com/xomino/extjs.nsf

or on the blog

http://xomino.com/extjs

but also check out the examples on the sencha page

http://docs.sencha.com/extjs/4.2.2/extjs-build/examples/

MarkyRoden
  • 1,074
  • 6
  • 21