Home » Developer & Programmer » Forms » display execl in forms data block item
icon4.gif  display execl in forms data block item [message #225756] Wed, 21 March 2007 05:17 Go to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

please tell how to display excel file in any forms data block item??Is it possible?
Re: display execl in forms data block item [message #225910 is a reply to message #225756] Wed, 21 March 2007 22:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of Forms are you using?

You can convert the excel spreadsheet to a flat file and read it directly, or convert it to a flat file and associate it with your data as an external table, or use ole2 to handle the original excel spreadsheet.

For external tables have a look at http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm and the sub-heading "Managing External Tables".

David
Re: display execl in forms data block item [message #225922 is a reply to message #225910] Wed, 21 March 2007 23:45 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

hi martin
Thanks for replying..I am using forms 10g .But i want to display the excel file in some block item where we can interact with it...
Re: display execl in forms data block item [message #225932 is a reply to message #225922] Thu, 22 March 2007 00:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at this one:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/

David
Re: display execl in forms data block item [message #225947 is a reply to message #225932] Thu, 22 March 2007 01:24 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

David,i have been able to read excel sheet values but what i actually want is to display my excel sheet cells as it is in my block(embedded in my block with other items also visible).Which item can i use to display the excel cells in my block????

Ritika
Re: display execl in forms data block item [message #225956 is a reply to message #225947] Thu, 22 March 2007 01:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Read the Excel cell and display it in a non-database item.

Would you care for some links to threads on how to build and run non-database block forms?

David
Re: display execl in forms data block item [message #225977 is a reply to message #225956] Thu, 22 March 2007 02:43 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

but david i want to display the worksheet in excel AS IT IS...
in my block which has others items also....
Thanks
Ritika
Re: display execl in forms data block item [message #226210 is a reply to message #225977] Thu, 22 March 2007 20:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.oracle.com/technology/products/forms/htdocs/forms904FAQ.html which contains
2.3 When running a form on the Web, can I use OLE to talk to programs such as MS Word or Excel?
Yes. For OLE integration on the client, Oracle have provided a utility called WebUtil for client-side integration. For more information on WebUtil, including a WebUtil FAQ, visit the WebUtil area on OTN.

OLE integration also works for external OLE servers invoked using OLE2.CREATE_OBJ. The OLE server you are invoking must be available on the middle tier machine where OracleAS Forms Services resides. Consequently the middle tier machine must be a Windows NT or Windows 2000 machine. Embedded OLE containers and ActiveX (OCX) controls are not supported when running on the Web.

Also have a look at http://www.oracle.com/technology/products/forms/pdf/ClientSideOLE.pdf

David

[Updated on: Thu, 22 March 2007 20:29]

Report message to a moderator

Re: display execl in forms data block item [message #226293 is a reply to message #226210] Fri, 23 March 2007 03:43 Go to previous message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

Thanks David i have been able to solve my problem with the links provided by you.
Thanks & Regards
Ritika
Previous Topic: Trigger when exit in Oracle
Next Topic: button to delete
Goto Forum:
  


Current Time: Sat Dec 10 20:20:13 CST 2016

Total time taken to generate the page: 0.14802 seconds