1 2 Previous Next 20 Replies Latest reply: Jan 17, 2013 3:58 AM by Hani Go to original post RSS
      • 15. Re: Read data from excel
        Hani
        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
          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
            Same error,

            Can i know what is the error retrieve from OLE?
            • 18. Re: Read data from excel
              Hani
              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
                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
                  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