Hi
I try to read data from excel but always get message non-oracle-excetpion for code
workbook := ole2.get_obj_property (workbooks, 'Open', args);
Full code
application := ole2.create_obj ('Excel.Application');
ole2.set_property (application, 'Visible', 'false');
workbooks := ole2.get_obj_property (application, 'Workbooks');
args := ole2.create_arglist;
ole2.add_arg (args, filename); -- file path and name
--*******************************
workbook := ole2.get_obj_property (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);
Note that its work in window XP but not work in windows server 2008,
in both server have Microsoft office 2007
Edited by: Hani on Jan 6, 2013 4:27 PM