OraFAQ Forum: Forms » client

Home » Developer & Programmer » Forms » client_ole2(oracle 10G)

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

client_ole2(oracle 10G) [message #360998]

Mon, 24 November 2008 10:49

jitender.sadh
Messages: 86
Registered: May 2007

Member

Hi All,

i am using the below code to view the excel file by passing the parameters

Procedure View_File (v_FileName in varchar2) is
v_ViewFile varchar2(100);
args ole2.list_type;
application ole2.obj_type;
workbooks ole2.obj_type;
workbook ole2.obj_type;
worksheets ole2.obj_type;
worksheet ole2.obj_type;
temp varchar2(200);
Begin
change_attrib(v_filename,'1');
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,filelocation||v_filename);
workbook := ole2.get_obj_property(workbooks,'Open',args);
ole2.destroy_arglist(args);
ole2.release_obj(workbooks);
ole2.release_obj(workbook);
ole2.release_obj(application);
End View_File;

but i want to add the functionality that when user close the excel sheet it show the dialog box saveas and ask the user for the folder in he want to save the excel file.

Best Regards
Jitender

Report message to a moderator

Re: client_ole2(oracle 10G) [message #361079 is a reply to message #360998]

Tue, 25 November 2008 00:27

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

Senior Member
Account Moderator

Report message to a moderator

Re: client_ole2(oracle 10G) [message #361910 is a reply to message #361079]

Fri, 28 November 2008 09:20

jitender.sadh
Messages: 86
Registered: May 2007

Member

Hi All,

Actually i want to change the property of file as read only or open it in read only mode by using client_ole2 at runtime.

Best Regards
Jitender

Report message to a moderator

Re: client_ole2(oracle 10G) [message #362365 is a reply to message #361910]

Tue, 02 December 2008 00:58

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

Senior Member
Account Moderator

Googling 'read only ole2' I found http://www.unix.com/unix-advanced-expert-users/55492-how-read-data-excel-sheet-use-those-data-variable-unix-c.html which points to http://search.cpan.org/~tmtm/Spreadsheet-ParseExcel-Simple-1.04/lib/Spreadsheet/ParseExcel/Simple.pm
and http://forums.devarticles.com/general-programming-help-4/win32-ole-open-excel-file-as-read-only-106369.html

Try contacting these people and see if they ever got an answer.

David

Report message to a moderator

Previous Topic:	where i can get JavaBeans for sound
Next Topic:	oracle.forms.webutil.host.Host bean not found.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 18:18:25 CDT 2025