Creating a 'general object' in an entry form

D

dev_prog

Hi Java gurus,
I was wondering whether you have a solution or can throw an advice on
the following idea.
In the near future, I'm hoping to build an entry form for users to
enter something like an invoice. This will contain some fields on top
(name, date, address, ...) and a list of items.
The reason for this message is that user wants to copy-paste the list
contents from an Excel spreadsheet. I mean the operator selects a
matrix of cells with the mouse, he/she then will copy that selected
area and paste it inside this form I'm hoping to build.
The 2 questions to you are:
q1. do you know of a certain control/class/object in Java that
receives a matrix of cells from the clipboard (the edit-paste
function)?
q2. If yes then would you explain how to process the contents of this
object (eg row-by-row then cell-by-cell inside the row).
If you have positive reply for the above idea then I can build the
whole front end as a Java client-side applet or as a Java client-side
stand-alone application. I used to write code in J2SE.
On the other hand, if this isn't doable in Java then can you suggest
another front-end language for the same idea? I doubt that standard
HTML has this sort of input field in the <form>...<input>...</form>
block. I'm very comfortable with PHP but not sure if it accepts this.
Microsoft ASPX isn't one of my strengths but can learn it if you deem
it the only solution.
Thanking you gurus in advance.
Kind regards,

Dev
 
L

lord.zoltar

Hi Java gurus,
I was wondering whether you have a solution or can throw an advice on
the following idea.
In the near future, I'm hoping to build an entry form for users to
enter something like an invoice. This will contain some fields on top
(name, date, address, ...) and a list of items.
The reason for this message is that user wants to copy-paste the list
contents from an Excel spreadsheet. I mean the operator selects a
matrix of cells with the mouse, he/she then will copy that selected
area and paste it inside this form I'm hoping to build.
The 2 questions to you are:
q1. do you know of a certain control/class/object in Java that
receives a matrix of cells from the clipboard (the edit-paste
function)?

Hmm.. I haven't done too much of this myself in Java, but I would
suggest looking into Data Grid controls. They should be able to handle
the pasting of cells.
 
R

Roedy Green

The reason for this message is that user wants to copy-paste the list
contents from an Excel spreadsheet. I mean the operator selects a
matrix of cells with the mouse, he/she then will copy that selected
area and paste it inside this form I'm hoping to build.

If you have an Applet, you might:

1. use the clip board feature to accept whatever is in the clipboard.
See http://mindprod.com/applet/quoter.html
It uses the feature when you run it at an Application.

2. upload the spreadsheet as a file and deal with it at the server.
See http://mindprod.com/jgloss/poi.html

3. do some cleverness in the spreadsheet to compose a computer
friendly message, e.g. CSV, or a CGI GET
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top