Excel Clipboard Compatible DataGrid for Web

Started by hatton.tom, March 05, 2012, 06:50:20 AM

hatton.tom

Hi Guys

I am looking to develop a data entry tool for a user interface. This tool is to replace an existing process that is mainly conducted within Excel.

Current Process:

Users have a blank template of a form (in Excel) that they intend to populate. This template has a header section, and a lines section.

In terms of the data entry itself; they receive a report in Excel, and basically copy and paste particular rows/columns to the lines area of this blank template - until the template is populated. They then save this, and e-mail it out.

This Excel culture needs to be cut back - but unfortunately we are not in a position at the moment to be able to output the initial report in anything but Excel. I'm trying to find a tool to handle the lines aspect of this that can sit in a webpage with the rows/columns corresponding to a newly created table in a database (either mysql or oracle) - or at least the capability of the data ultimately populating a database table.

The requirements here are specifically:
To give the users a tool that it is equally as easy to enter two lines of data into, as it is 300.
The columns can be predetermined (by admin)
Clipboard compatibility with Excel
Ability to put the data into a database

The header details are far simpler to manage, as like usual, there is only one header per instance.

Do you have any suggestions for something that may be suitable?

Thanks in advance for any help