OraFAQ Forum: Forms » Copy Rows from Excel Paste in Forms

Home » Developer & Programmer » Forms » Copy Rows from Excel Paste in Forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copy Rows from Excel Paste in Forms [message #270832]

Fri, 28 September 2007 02:17

craidt
Messages: 2
Registered: September 2007
Location: Germany

Junior Member

Hey,

I want to copy some rows in one column from Excel and Paste
it in a Oracle Forms Progam. Normaly with the clipboard. But my Oracle Forms 6i Program copy alle the rows in one Field, seperated with a | character. But I need it in several rows. Is this posible?

Greetings

Carsten

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #270858 is a reply to message #270832]

Fri, 28 September 2007 03:25

anisam10674
Messages: 18
Registered: March 2007

Junior Member

I guess you have tried the copy_region and paste_region built-ins

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #270881 is a reply to message #270858]

Fri, 28 September 2007 04:30

craidt
Messages: 2
Registered: September 2007
Location: Germany

Junior Member

Hey,

yes i had tested the paste_region build in, its the same
all data are in one Field. I don't use the copy_region,
because the data came from excel and i make a normal copy
to the clipoard in excel.

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #271768 is a reply to message #270881]

Tue, 02 October 2007 19:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Consider this: add a when-mouse-doubleclick trigger to the item into which you are placing the data. In this trigger, move the data into a local variable, parse it for '|', and place the data pieces into the items you require, you do a 'create_record' to add new records.

David

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #449026 is a reply to message #271768]

Fri, 26 March 2010 05:27

josegante
Messages: 3
Registered: March 2010

Junior Member

Hi!

I'm trying to implement the solution suggested by djmartin, but my problem is that I get FRM-40218 error using procedure PASTE_REGION (Forms 6i, EBS 11.5.9).

Any help!?

Thanks a lot in advance,
Jose.

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #449281 is a reply to message #449026]

Mon, 29 March 2010 01:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Googling 'FRM-40218' returned http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_20576270.html

Does the described machine configuration reflect your configuration?

David

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #450269 is a reply to message #449281]

Tue, 06 April 2010 02:29

josegante
Messages: 3
Registered: March 2010

Junior Member

Hi David!

Thanks for your answer, but unfortunately I found the post you suggested as well, and I couldn't see the answer as I have to pay for seeing it!

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #450272 is a reply to message #450269]

Tue, 06 April 2010 02:50

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would you like David to pay it for you?

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #450278 is a reply to message #450272]

Tue, 06 April 2010 03:45

josegante
Messages: 3
Registered: March 2010

Junior Member

No, as David is doing enogh for helping.

Just like you. Helpful comment.

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #450282 is a reply to message #450278]

Tue, 06 April 2010 03:56

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I couldn't resist /forum/fa/1599/0/

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #451333 is a reply to message #450269]

Wed, 14 April 2010 01:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to the bottom of the page.

David

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #451341 is a reply to message #450269]

Wed, 14 April 2010 01:58

deepankar_04
Messages: 29
Registered: August 2009
Location: Udaipur, Rajasthan, INDIA

Junior Member

Yes you are right josegante, may be David is member of that site but non paid members can't able to see it.But I tell you a method to seeing that post on expert-exchange site.
just copy the whole link, open www.google.com in browser, then paste the whole link in it. After that you just click on a cache link seeing beside that link side.

or
see http:// webcache.googleusercontent.com/search?q=cache:5RbxsDTroUsJ:www.experts-exchange.com/Database/Oracle/Product_Info/Q_20576270.html+http ://www.experts-exchange.com/Database/Oracle/Product_Info/Q_20576270.html&cd=1&hl=en&ct=clnk&gl=in

Here you go to the bottom of the web-page.

[Updated on: Wed, 14 April 2010 02:06]

Report message to a moderator

Re: Copy Rows from Excel Paste in Forms [message #451355 is a reply to message #451341]

Wed, 14 April 2010 02:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I am a member but I do not pay anything, nor have I answered a question in many years.

David

Report message to a moderator

Previous Topic:	Error in CSV file generation (merged by CM)
Next Topic:	Date Initial Value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:37:26 CDT 2024