Solved

Drag and Drop Excel Column to Database Column in JSP

Posted on 2006-07-14
4
410 Views
Last Modified: 2010-04-01
Maybe I'm trying to do the impossible.  

I have developed a desktop application that allows the user to select an Excel spreadsheet and a MySql table.  On the left side of the screen, all of the columns for the selected table are displayed.  On the right side of the screen, all of the columns for the selected spreadsheet are displayed (along with some data that can be browsed).  

The user can then drag the Excel column, from the right, to the row containing the corresponding table column on the left.  When they let go, the name of the Excel column is placed in an empty "cell" next to the table column name.  

Once all columns are selected, they then click on an "import" button and the data found in the Excel columns that have been selected for importing are imported into the table (into the table columns that they were placed next to, i.e. if Excel column Boots was dropped on MySql table column Cloths, all the data in the Boots Excel column is inserted into the MySql table in column Cloths).  

Long story short, is there any way that this can be done using Java and JSP?  I am attempting to re-write the application to make it web based, but this one function could be a show stopper.   Thanks in advance for your help.

0
Comment
Question by:ronrea
  • 2
4 Comments
 
LVL 4

Expert Comment

by:Meritor
ID: 17113728
Yes, this is possible.

You have to use javacript,css, jsp, and java to achieve this.
You may have to write lengthy code for the same.

Now the question is How to do?
For this I just lead you to the way, you must think logic for that. However if you have any question you can ask.
Please refer to this links...

http://tool-man.org/examples/
http://tool-man.org/examples/sorting.html
0
 

Author Comment

by:ronrea
ID: 17115961
Thanks for the suggestion, Meritor.  I know how to drag and drop from one text field within a page to another, but how can I load the Excel column data on one side of the screen, the table column data on the other, and so on (the rest of the process)..., all within a JSP.    Should I call an ASP page and have it do the work using the same objects used in the vb app?
0
 
LVL 4

Accepted Solution

by:
Meritor earned 175 total points
ID: 17121298
0
 
LVL 3

Assisted Solution

by:mdg12
mdg12 earned 75 total points
ID: 17123403
It does sound like this is going to become mostly an exercise in DHTML/Javascript

For reading an Excel file, I recommend the JExcel API

You can download it here:
http://www.andykhan.com/jexcelapi/

An good user community exists for help:
http://groups.yahoo.com/group/JExcelApi/
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

One of the biggest threats in the cyber realm pertains to advanced persistent threats (APTs). This paper is a compare and contrast of Russian and Chinese APT's.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now