Results 1 to 4 of 4
- 03-07-2012, 11:08 AM #1Member
- Join Date
- Mar 2012
- Rep Power
Datagrid - Excel Clipboard Compatible
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.
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/object to handle the lines aspect of this that can sit in a webpage with the columns corresponding to a database (either mysql or oracle) - or at least the capability of the data ultimately populating a database table. Each row should become a new record when the submit button is pressed (of course with validation if necessary)
The requirements here are specifically:
To give the users a tool that it is equally as easy to enter 2 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
- 03-09-2012, 11:28 PM #2
Re: Datagrid - Excel Clipboard Compatible
A Java app you code yourself?
- 03-10-2012, 01:23 AM #3
Re: Datagrid - Excel Clipboard CompatibleIf you're forever cleaning cobwebs, it's time to get rid of the spiders.
- By delican in forum New To JavaReplies: 5Last Post: 08-05-2011, 10:32 PM
- By Aga^^ in forum JavaServer Faces (JSF)Replies: 0Last Post: 08-24-2010, 10:52 AM
- By sandeeppallapothu in forum JavaServer Pages (JSP) and JSTLReplies: 0Last Post: 07-30-2009, 10:59 AM
- By samson in forum JavaServer Pages (JSP) and JSTLReplies: 3Last Post: 03-16-2009, 12:36 AM
- By Eku in forum JavaServer Pages (JSP) and JSTLReplies: 3Last Post: 08-20-2008, 07:52 AM