Home » Developer & Programmer » Forms » client_ole2(oracle 10G)
client_ole2(oracle 10G) [message #360998] Mon, 24 November 2008 10:49 Go to next message
jitender.sadh
Messages: 82
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
Re: client_ole2(oracle 10G) [message #361079 is a reply to message #360998] Tue, 25 November 2008 00:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please use '[code]' tags.

These are my favourite links for Excel
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
http://www.orafaq.com/forum/t/101906/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Excel via DDE
http://www.orafaq.com/forum/m/260061/67467/#msg_260061
Import from Excel
http://www.orafaq.com/forum/mv/msg/32353/86299/67467/#msg_86299
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/
How to kill EXCEL.exe from Task Manager from Oracle Forms
http://www.orafaq.com/forum/t/88643/67467/
how do i display all excel worksheets name in form
http://www.orafaq.com/forum/t/89775/67467/
More Excel stuff
http://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358
create excel chart in form6I/How to SetSourceData into excel.chart in form6i
http://www.orafaq.com/forum/t/99738/67467/
Call Excel file from Forms
http://www.orafaq.com/forum/t/121433/67467/

Go through them and perhaps PM the main posters to see if they can help you.

David
Re: client_ole2(oracle 10G) [message #361910 is a reply to message #361079] Fri, 28 November 2008 09:20 Go to previous messageGo to next message
jitender.sadh
Messages: 82
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
Re: client_ole2(oracle 10G) [message #362365 is a reply to message #361910] Tue, 02 December 2008 00:58 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: where i can get JavaBeans for sound
Next Topic: oracle.forms.webutil.host.Host bean not found.
Goto Forum:
  


Current Time: Fri Dec 09 15:43:47 CST 2016

Total time taken to generate the page: 0.29007 seconds