How to make an AJAX spreadsheet or an editable and navigatable web table/grid?

Question

Many web applications today have spreadsheets. I was trying to make a very similar table, but with reduced funcionality:

1. editable cells
2. pressing the arrow keys, or would make you go to a cell next to the current one (in the proper direction)

I found ext grid and YUI DataTable, and besides they being editable I haven't found an easy way to make them keyboard navigatable.

Anyone knows how to configure them properly? Anyone knows another JS library that would help me?

Answer 1

Use either of those grids, and just watch the keyboard keyup event. Check if it's an arrow, and if so, move the focus. Both those grids support selecting the cell via code, so you should be good to go.

Answer 2

http://os.arandomurl.com/jqueryspreadsheet/ arrows work

http://plugins.jquery.com/project/sheet