| excel to form 10g [message #218779] |
Sat, 10 February 2007 02:51  |
geetav
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
Hi,
I want to transfer data from excel to form10g . is there any setting require for this. excel is office11/2003. Though I tried with OLE2 and installed webutil but it is givng me error frm-40735 / ora-30550 in get_obj_property.
Anyone there who can help  .................
|
|
|
|
|
|
|
|
| Re: excel to form 10g [message #220075 is a reply to message #219140] |
Sun, 18 February 2007 11:28  |
geetav
Messages: 2
Registered: February 2007
|
Junior Member |
|
|
application:=OLE2.CREATE_OBJ('Excel.Application'); OLE2.Set_Property(application,'Visible', 'True');
workbooks := ole2.get_obj_property(application, 'Workbooks'); (IN THIS LINE IAM GETTING ERROR)
args:= ole2.create_arglist;
ole2.add_arg(args,filename_var);
workbook := ole2.invoke_obj(workbooks, 'Open', args); ole2.destroy_arglist(args); args:= ole2.create_arglist; ole2.add_arg(args, 'Sheet1'); worksheet := ole2.get_obj_property(workbook, 'Worksheets', args); ole2.destroy_arglist(args);
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
