| Use OLE2 packege in Forms&Reports 6.0. [message #155366] |
Sun, 15 January 2006 03:01  |
foreverth
Messages: 5
Registered: November 2005
|
Junior Member |
|
|
I want to export Report to Excel file using OLE2.
In Oracle help is only basic example how to make Excel file using OLE:
application:=OLE2.CREATE_OBJ('Excel.Application');
OLE2.Set_Property(application,'Visible', 'True');
workbooks:=OLE2.INVOKE_OBJ(application, 'Workbooks');
workbook:=OLE2.INVOKE_OBJ(workbooks,'Add');
worksheets:=OLE2.INVOKE_OBJ(workbook, 'Worksheets');
worksheet:=OLE2.INVOKE_OBJ(worksheets,'Add');
args:=OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(args, 4);
OLE2.ADD_ARG(args, 2);
cell:=OLE2.Invoke_Obj(worksheet, 'Cells', args);
OLE2.DESTROY_ARGLIST(args);
OLE2.Set_Property(cell, 'Value', 'Hello Excel!');
It's works but I don't know how to change Font Style or Font Name or add border to cells.
Thank You for help
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
