This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Jan 17, 2013 1:58 AM by Hani Go to original post RSS
  • 15. Re: Read data from excel
    Hani Explorer
    Currently Being Moderated
    I changed the code as your note like below but it still have same error
    application := ole2.create_obj ('Excel.Application');
    ole2.set_property (application, 'Visible', 0);
    workbooks := ole2.get_obj_property (application, 'Workbooks');
    args := ole2.create_arglist;
    ole2.add_arg (args, filename);
    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);
    and code ole2.lastexception not compiled ?
  • 16. Re: Read data from excel
    vansul Pro
    Currently Being Moderated
    copy this code


    application := ole2.create_obj ('Excel.Application');
    ole2.set_property (application, 'Visible', 0);
    workbooks := ole2.get_obj_property (application, 'Workbooks'); remove this code as commented
    args := ole2.create_arglist;
    ole2.add_arg (args, filename);
    workbook := ole2.invoke_obj (application, 'Open', args); -- requires application obj here
    ole2.destroy_arglist (args);
    args := ole2.create_arglist;
    ole2.add_arg (args, '1');
    worksheet := ole2.get_obj_property (workbook, 'Worksheets', args);
    ole2.destroy_arglist (args);
  • 17. Re: Read data from excel
    Hani Explorer
    Currently Being Moderated
    Same error,

    Can i know what is the error retrieve from OLE?
  • 18. Re: Read data from excel
    Hani Explorer
    Currently Being Moderated
    Note that its work in application server that deployed at windows XP but not work on other server that have Windows server 2008, and both have same Microsoft office 2007
  • 19. Re: Read data from excel
    Askdineshsingh Explorer
    Currently Being Moderated
    this type of prolem occures when you try to use webutil which is not registered to you local machine
    then your programme compile correctly but at runtime it gives error Like Non Oracel exception
    . You need to have sign your webutil with jar signer. if you need the more help then write to me about how to sign webutil with jarsigner. Your problem might be solved. If you find this information correct then mark it helpful/correct.
  • 20. Re: Read data from excel
    Hani Explorer
    Currently Being Moderated
    I already sign webutil and use it in different forms at same applications,

    Finaly i found solution, this solution related to windows and office version.
    use this lilnk:
    http://bigdaveroberts.wordpress.com/2012/11/17/oracle-forms-11g-ole2-windows-2008-r2-64bit-issue-possibly
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points