2

What are some efficient ways to insert/change some amount of data in a web application for users that are used to do it in Excel sheets?

(the most efficient could be kind of subjective, and I would like to see several opinions)

2

I have found that for Excel-like applications, the best solution is simply to emulate Excel. So, to change a data cell for example, make any cell editable once clicked. To insert data, use the commands from an Insert menu.

The Google docs spreadsheet app has done an excellent job of making a web app behave in ways expected from users of it's desktop counterpart, and is a good place to look for examples and patterns you can emulate.

  • Would you say something like this: demos.telerik.com/aspnet-mvc/grid/editingbatch?theme=vista ? Thanks. – Nelson Reis Nov 22 '11 at 16:36
  • 1
    Yes, that seems like a nice example, and the cell data editing works well. There are some nice subtle touches in that example too, such as being able to increment values using keypad arrows. My only minor complaint would be the delete buttons in a column. I generally prefer a select column on the far left of the table with checkboxes, and the ability to multi-delete and apply any other commands as a batch. – Nadine Schaeffer Nov 22 '11 at 22:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.