OraFAQ Forum: Forms » display execl in forms data block item

Home » Developer & Programmer » Forms » display execl in forms data block item

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

display execl in forms data block item [message #225756]

Wed, 21 March 2007 05:17

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?

Report message to a moderator

Re: display execl in forms data block item [message #225910 is a reply to message #225756]

Wed, 21 March 2007 22:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: display execl in forms data block item [message #225922 is a reply to message #225910]

Wed, 21 March 2007 23:45

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...

Report message to a moderator

Re: display execl in forms data block item [message #225932 is a reply to message #225922]

Thu, 22 March 2007 00:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: display execl in forms data block item [message #225947 is a reply to message #225932]

Thu, 22 March 2007 01:24

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

Report message to a moderator

Re: display execl in forms data block item [message #225956 is a reply to message #225947]

Thu, 22 March 2007 01:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: display execl in forms data block item [message #225977 is a reply to message #225956]

Thu, 22 March 2007 02:43

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

Report message to a moderator

Re: display execl in forms data block item [message #226210 is a reply to message #225977]

Thu, 22 March 2007 20:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

Report message to a moderator

Previous Topic:	Trigger when exit in Oracle
Next Topic:	button to delete

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:08:14 CST 2025