Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy from Applet to Excel

Status
Not open for further replies.

hilbertl3

Technical User
Sep 22, 2004
77
US
All,

I need to copy/paste or download the contents of an applet accessed through an https site to my desktop. However,
when I select all the worksheet rows displayed in the applet then do CTRL-C and CTRL-V, nothing appears in my target app, Excel. Does anyone know of a way to do this?

Thank you,

hilbertl
 
For an applet to interact with the clipboard, it has to be trusted and signed. Answer yes to questions your browser asks you about trusting this applet. If this is a vendor supplied applet, then ask them if they supply a signed one. If it is one you wrote yourself, then you will have to investigate how to sign it.

HTH

Mark [openup]
 
It is not an applet that I created myself. At the prompt I do click the button "Grant" to trust the applet. However, CTRL-C and CTRL-V still aren't working.

hilbertl
 
They may not have included code to handle Ctrl-C and Ctrl-V... They could have made copy and paste whatever it is on their system (some programs used to use Shift+Insert, Ctrl+Insert ... Linux it happens on highlight) or they could have not added copy and paste functionality to thier applet.
 
I tried the Ctrl-insert, shift-Insert
but this didn't work. Is there any way to copy the data otherwise? Its very frustrating to see it sitting there right in front of me but be unable to get it. If I can't copy it, I'll need to ask someone to spend about 3 days typing it up in a spreadsheeet manually.
Thanks for your replies.

h
 
I don't think it's an OS problem. If it is, you'd just need to select the data and right click it to show the copy option.

Some applications intentionally disable copy/paste operations ... could this be the case?

Cheers,

Dian
 
Yes, I think it may have been disabled intentionally.
When I right-click, no options show up...
Is there another way?
 
I don't think there's a Java way to do that.

If it's intentional and well done, you will need to crack the application.

Cheers,

Dian
 
You could try grabbing the data using a *nix OS, which copis anything/everything you highlight... It takes quite a bit of code to get arround it... And unless their really paranoid, my guess is they didn't get to it.

What I was saying was that they had to add copy and paste functionality in order to have it in the first place. And what key-combo they used or if they add it at all is up to the developer.
 
Could you give me an example of a *nix OS?
I'm not familiar.

hilbertl
 
*nix OS, sorry for the confussion... Linux, Unix, BSD, Hurd et al are POSIX or POSIX like OSes that are all modeled after Unix. If you have access to a Linux machine or have CYGWIN (and the X libraries for it) installed on your windows machine, then you can copy the information into a flat file at least.

It may be more hoops to jump through than is worth it, unless you have a linux box laying arround. Then getting it into excel would still be a challenge...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top