Home » Developer & Programmer » Forms » how to integrate excel with forms (forms 10g)
how to integrate excel with forms [message #445572] Tue, 02 March 2010 11:05 Go to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
Hi,

how to integrate exel with oracle forms ? so that it looks like a detail block.

and how to change the number of records displayed in a detail block at run time?

if i give 20 in text item and if i click on a button then the detail block should display 20 records.

in set_block_property there is no property for records_displayed. but in get_block_property we have it.

thanks
jillu
Re: how to integrate excel with forms [message #445573 is a reply to message #445572] Tue, 02 March 2010 11:17 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can't set records_displayed programatically. Form Builder help does tell you that.
The fact that you can reference it it get_block_property proves nothing. If you compare the property list for get and set (at both block and item level) you'll find that there are several properties that you can get but not set.

As for the excell question - no idea, hopefully someone else will know.
Re: how to integrate excel with forms [message #445659 is a reply to message #445572] Wed, 03 March 2010 03:52 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
Just to add I very much doubt you'll be able to make excell look like a datablock.
Re: how to integrate excel with forms [message #445683 is a reply to message #445572] Wed, 03 March 2010 06:15 Go to previous messageGo to next message
Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium
Member
What you could do is save excell file as CSV
and use an external table and base your block on that
Re: how to integrate excel with forms [message #445718 is a reply to message #445683] Wed, 03 March 2010 09:46 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
hi martin,

i didnot understand about using external table.
do u want me to create a table and insert records from csv file into that table and base block on this table??

--jillu
Re: how to integrate excel with forms [message #445721 is a reply to message #445572] Wed, 03 March 2010 09:57 Go to previous messageGo to next message
Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium
Member
I guess you are not familiar with what an external table is

here is a good tutorial : http://www.orafaq.com/node/848
Re: how to integrate excel with forms [message #445756 is a reply to message #445721] Wed, 03 March 2010 21:54 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
i understtod the concept of external tables, but its almost same as a detail block based on a table.

but i want to show the EXCEL in the FORM as a detail block. see the attached image. the detail block with many rows and columns should be an EXCEL.

-- jillu




CM: deleted attached image at OPs request.

[Updated on: Thu, 04 March 2010 08:30] by Moderator

Report message to a moderator

Re: how to integrate excel with forms [message #445758 is a reply to message #445756] Wed, 03 March 2010 22:45 Go to previous messageGo to next message
arunn
Messages: 52
Registered: September 2008
Location: usa
Member
u can use the ocx
Re: how to integrate excel with forms [message #445759 is a reply to message #445756] Wed, 03 March 2010 22:47 Go to previous messageGo to next message
arunn
Messages: 52
Registered: September 2008
Location: usa
Member
more http://download.oracle.com/docs/cd/A97335_02/apps.102/a73073/d2kopen.htm#1006972
Re: how to integrate excel with forms [message #445943 is a reply to message #445759] Thu, 04 March 2010 18:20 Go to previous messageGo to next message
arunn
Messages: 52
Registered: September 2008
Location: usa
Member
arunn wrote on Wed, 03 March 2010 22:47
more http://download.oracle.com/docs/cd/A97335_02/apps.102/a73073/d2kopen.htm#1006972



right one is ole container, insert the object as oracle spreadsheet common ....

sorry i forgot the right name, but its start with oracle spreadsheet.... just see in the object list.....
Re: how to integrate excel with forms [message #447406 is a reply to message #445943] Mon, 15 March 2010 01:29 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This looks like the same question as asked in http://www.orafaq.com/forum/t/155580/67467/

David
Previous Topic: FRM-40202: Field must be entered.
Next Topic: Restricting entry from keyboard
Goto Forum:
  


Current Time: Sat Oct 01 14:28:19 CDT 2016

Total time taken to generate the page: 0.15580 seconds