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
------------------------------
Original Message:
Sent: Mon September 07, 2020 08:36 AM
From: Pedro Fernandes
Subject: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.
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
Original Message:
Sent: Mon September 07, 2020 03:47 AM
From: Daniel Junglas
Subject: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.
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
Original Message:
Sent: Mon September 07, 2020 12:42 AM
From: Pedro Fernandes
Subject: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.
Have you solved this problem?
I've been used 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
Original Message:
Sent: Tue July 14, 2020 04:13 PM
From: Florian Stroh
Subject: Error Message: Ausnahme von IBM ILOG Concert: Impossible to create an instance of Excel.
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
------------------------------
#DecisionOptimization