Results 1 to 4 of 4
Like Tree1Likes
  • 1 Post By quad64bit

Thread: Datagrid - Excel Clipboard Compatible

  1. #1
    Hatton.Tom is offline Member
    Join Date
    Mar 2012
    Rep Power

    Default 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.

    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.

    Going Forward:

    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

  2. #2
    quad64bit's Avatar
    quad64bit is offline Moderator
    Join Date
    Jul 2009
    Rep Power

    Default Re: Datagrid - Excel Clipboard Compatible

    A Java app you code yourself?
    Fubarable likes this.

  3. #3
    DarrylBurke's Avatar
    DarrylBurke is offline Forum Police
    Join Date
    Sep 2008
    Madgaon, Goa, India
    Rep Power

    Default Re: Datagrid - Excel Clipboard Compatible

    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  4. #4
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Blog Entries
    Rep Power

    Default Re: Datagrid - Excel Clipboard Compatible

    It doesn't matter where else he's spammed this since quad has given the definitive answer.

Similar Threads

  1. swing datagrid or dataview problem
    By delican in forum New To Java
    Replies: 5
    Last Post: 08-05-2011, 10:32 PM
  2. Rich:DataGrid Problem
    By Aga^^ in forum JavaServer Faces (JSF)
    Replies: 0
    Last Post: 08-24-2010, 10:52 AM
  3. example for datagrid in jsp
    By sandeeppallapothu in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 07-30-2009, 10:59 AM
  4. Jsp Datagrid
    By samson in forum JavaServer Pages (JSP) and JSTL
    Replies: 3
    Last Post: 03-15-2009, 11:36 PM
  5. DataGrid in JSP
    By Eku in forum JavaServer Pages (JSP) and JSTL
    Replies: 3
    Last Post: 08-20-2008, 07:52 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts