Decision Optimization

  • 1.  Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Wed July 15, 2020 03:55 AM

    I got the error massage: 

    Exception from IBM ILOG Concert: Impossible to create an instance of Excel.

    When does this error occur and how can I solve it?
    I used all files (.mod, .ops, .dat, .xlsm,.txt) half a year ago without any error message and stopped using CPLEX since then. Now I have to use it again and got the error message. I`m using EXCEL 2019 and CPLEX 12.10.0

    The error occurs at the SheetConnection command to connect my EXCEL file to CPLEX.

    I used the Sheet Connection command like this:
    SheetConnection scheduled("Test.xlsx");

    It seems my CPLEX does not load any EXCEL file in general, because every other EXCEL document gets the same error message.

    Thanks for your help.



    ------------------------------
    Florian Stroh
    ------------------------------


  • 2.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Mon September 07, 2020 03:40 AM
    Edited by Pedro Fernandes Mon September 07, 2020 08:24 AM
    Have you solved this problem? 

    I've been using CPLEX for 2 years. However, it has happened to me since yesterday, and it is not related to the code once the .dat file used to perfectly import data from excel.

    ------------------------------
    Pedro Fernandes
    ------------------------------



  • 3.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Mon September 07, 2020 03:48 AM
    What exactly changed on your machine since yesterday? Or did you maybe move to a different machine? It would seem strange if this stopped working out of the blue. Maybe you had some (automatic) updates applied to some software on your machine?

    ------------------------------
    Daniel Junglas
    ------------------------------



  • 4.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Mon September 07, 2020 08:36 AM
    Edited by Pedro Fernandes Mon September 07, 2020 08:37 AM
    I was using the same machine and the same configurations, but it suddenly happened in the version 12.8.0 for Windows: Internal error (please contact IBM).
    Similarly to him: https://stackoverflow.com/questions/51680669/getting-an-internal-error-while-executing-code-on-ibm-cplex

    As a consequence, I downloaded the 12.10.0 version and then I got it: Exception from IBM ILOG Concert: Impossible to create an instance of Excel.

    Thanks for helping
    ------------------------------
    Pedro Fernandes
    ------------------------------



  • 5.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Tue September 08, 2020 04:11 AM
      |   view attached
    OPL uses the Excel COM component to launch an Excel instance and communicate with it.
    The message you have in 12.10 is an improvement over previous versions, it now shows the cause of the issue.
    It means that the COM object could not have been created.

    My guess is that something changed on your machine, maybe related to access rights to COM component.

    I have a pure Visual C++ sample that does the exact same thing as OPL, compiling it requires some tlh files to be generated
    from Excel exports files (see header)
    but the executable should work on any Windows machine.

    If the error reported is the same hen there are good chances your configuration does not allow anymore Excel COM component creation, for reasons I do not know (maybe security policy has changed)

    ------------------------------
    Frederic Delhoume
    ------------------------------

    Attachment(s)

    zip
    excelcom.zip   141 KB 1 version


  • 6.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Wed February 24, 2021 11:47 AM
    Edited by Olcay Polat Thu February 25, 2021 03:02 AM
    I am using CPLEX Optimization Studio more than 15 years without any problem. After installing version 20.1 my former projects that contains excel connection are not working and giving same error (0x8002802B). Before installing version 20.1, they were working at version 12.10.
    Any Idea?

    ------------------------------
    Olcay Polat
    ------------------------------



  • 7.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Thu February 25, 2021 02:49 AM

    Problem solved by repairing Office 365. It installed both 32 and 64 versions of Excel and Access. Then everything is fine.

    Solution steps are as follows:
    Open Microsoft Windows Settings.
    Click Apps to open the Apps & features window.
    Find and click your Microsoft application in the list, such as Microsoft Office 365.
    Select Modify, then Online Repair, and follow the onscreen instructions.

    I hope it helps.




    ------------------------------
    Olcay Polat
    ------------------------------



  • 8.  RE: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.

    Posted Mon October 25, 2021 03:08 PM
    Thank you, Olcay Polat ! Your solution worked. 

    ------------------------------
    Amanda Lopes
    ------------------------------