Home » Developer & Programmer » Forms » how to make open office/libre office excel document on linux with oracle forms (os:pardus (debian) forms:10.1.2.3)
icon4.gif  how to make open office/libre office excel document on linux with oracle forms [message #627978] Tue, 18 November 2014 08:46 Go to next message
mustundag
Messages: 2
Registered: September 2009
Location: istanbul
Junior Member

Hi,
our clients are using Oracle Forms to create excel files with ole2.
in linux platform that we want to use, there is libre office.
how to make this code avaible in linux libre office?

PROCEDURE EXCEL_DOSYA2 IS
application CLIENT_OLE2.obj_type;
workbooks CLIENT_OLE2.obj_type;
workbook CLIENT_OLE2.obj_type;
worksheets CLIENT_OLE2.obj_type;
worksheet CLIENT_OLE2.obj_type;
cell CLIENT_OLE2.obj_type;
args CLIENT_OLE2.list_type;
borders CLIENT_OLE2.obj_type;
rango CLIENT_OLE2.obj_type;
font CLIENT_OLE2.obj_type;
rowcount INTEGER;
.....
BEGIN
application := CLIENT_OLE2.create_obj('Excel.Application');
CLIENT_OLE2.set_property(application,'Visible','True');
workbooks := CLIENT_OLE2.get_obj_property(application,'Workbooks');
workbook := CLIENT_OLE2.invoke_obj(workbooks,'Add');
worksheets := CLIENT_OLE2.get_obj_property(workbook,'Worksheets');
worksheet := CLIENT_OLE2.invoke_obj(worksheets,'Add');
rowcount := 0;
rowcount :=rowcount+1;


args := CLIENT_OLE2.create_arglist;
CLIENT_OLE2.add_arg(args,rowcount);
CLIENT_OLE2.add_arg(args,1);
....
CLIENT_OLE2.release_obj(worksheet);
CLIENT_OLE2.release_obj(worksheets);
CLIENT_OLE2.release_obj(workbook);
CLIENT_OLE2.release_obj(workbooks);
CLIENT_OLE2.release_obj(application);
Re: how to make open office/libre office excel document on linux with oracle forms [message #628045 is a reply to message #627978] Wed, 19 November 2014 08:58 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Well, first and foremost CLIENT_OLE2 is a Windows library. So, the answer to your question is no - this will not work with any non-Windows OS. You would have to investigate using Java as your OLE layer assuming you are using Web deployed Forms (version 6i or higher). If you are using Client/Server - Java is not an option.

Craig...
Previous Topic: Asking on execute query
Next Topic: is it possible to Populate a list for a number field , using Record Group........"
Goto Forum:
  


Current Time: Thu Mar 28 13:44:06 CDT 2024