OraFAQ Forum: Forms » want to provide a link to an excel sheet in my form

Home » Developer & Programmer » Forms » want to provide a link to an excel sheet in my form

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

want to provide a link to an excel sheet in my form [message #86127]

Thu, 02 September 2004 01:56

roblvl
Messages: 27
Registered: June 2003

Junior Member

hi everybody ,

�� i want to provide a link to an excel sheet in my form .. how do i do this .Reply ASAP.

regards

Giri

�

Report message to a moderator

Re: want to provide a link to an excel sheet in my form [message #86143 is a reply to message #86127]

Fri, 03 September 2004 03:09

Narendra K.
Messages: 18
Registered: June 2003

Junior Member

Dear Giri,

U can use OLE object in the form & define
the target as your file u want to link.

When a user will will click over this object,
the file will be opened using excel in client's
machine.

have a nice day,

Narendra

Report message to a moderator

Re: want to provide a link to an excel sheet in my form [message #86159 is a reply to message #86127]

Sun, 05 September 2004 06:39

fanni
Messages: 96
Registered: March 2004

Member

Hi Giri
use this code to use OLE.
place a button on your form and paste this code on its when-button-pressed trigger

i wish it will work fine

Open excel report on click of pusg button
DECLARE
AppID PLS_INTEGER;
v_PATH VARCHAR2(110);
v_SHEETPATH VARCHAR2(200);
application ole2.obj_type;
workbooks ole2.obj_type;
workbook ole2.obj_type;
args ole2.list_type;

BEGIN

v_PATH :=get_application_property(current_form);
v_SHEETPATH := SUBSTR(v_PATH,1,INSTR(v_PATH,'',-1))||'SCHEDULE.XLS';
application:= ole2.create_obj('Excel.Application');
OLE2.SET_PROPERTY(application,'Visible',1);
workbooks := ole2.get_obj_property(application, 'Workbooks');
args:= ole2.create_arglist;
ole2.add_arg(args,v_SHEETPATH);
workbook := ole2.invoke_obj(workbooks, 'Open', args);
EXCEPTION WHEN OTHERS THEN
MESSAGE(sqlerrm);

END;

Report message to a moderator

Previous Topic:	forms on web browser
Next Topic:	List Item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 08:07:04 CDT 2024