How to use Gurobi in tandem with OpenSolver inside of Excel?
AnsweredI'm new to Gurobi and basically know nothing about its use.
I typically solve models by simply writing constraints in to OpenSolver inside of Excel. My next model is much larger, and I'd like to use Gurobi instead. (I've already got Gurobi installed on my computer and can set it to be the solver used in Excel.)
How do I read my data / constraints in to Gurobi in order to solve the model?
Thanks in advance for any assistance!
-
Official comment
This post is more than three years old. Some information may not be up to date. For current information, please check the Gurobi Documentation or Knowledge Base. If you need more help, please create a new post in the community forum. Or why not try our AI Gurobot?. -
I'm not aware of a way to call Gurobi from OpenSolver, but Solver Studio is a similar tool, and it supports Gurobi.
0 -
For the use of Gurobi by Excel it is necessary to have version 9.0.2 installed.
However it will be installed in the folder: C: \ gurobi902 \ win64 \ python37.
But excel can only read the way:
C: \ gurobi902 \ win64 \ python27
then just copy the files from the first and paste in the second.
There, you can now use Gurobi to solve the optimization problems developed by Excel.3 -
I am using opensolver. The model (simple one) provides optimized solution using CBC solver but the following error using gurobi.
0 -
Could you please post the output you see when you click "More Details"?
0 -
Hi, Thank you for your response.
0 -
That output tells us Gurobi is installed on your machine. I wonder if there is an issue with your license file. What output do you see when you open the command prompt and type:
C:\gurobi1002\win64\bin\gurobi_cl
0 -
C:\Windows\system32>C:\gurobi1002\win64\bin\gurobi_cl
Warning: Failed to open log file 'gurobi.log'
Set parameter LogFile to value "gurobi.log"Failed to set up a license
Error 10009: No Gurobi license found (user adeshmukh, host CALSPLADESHMUKH, hostid 1c5f7424, cores 4)
C:\Windows\system32>cd..
C:\Windows>C:\gurobi1002\win64\bin\gurobi_cl
Warning: Failed to open log file 'gurobi.log'
Set parameter LogFile to value "gurobi.log"Failed to set up a license
Error 10009: No Gurobi license found (user adeshmukh, host CALSPLADESHMUKH, hostid 1c5f7424, cores 4)
C:\Windows>cd..
C:\>C:\gurobi1002\win64\bin\gurobi_cl
Warning: Failed to open log file 'gurobi.log'
Set parameter LogFile to value "gurobi.log"Failed to set up a license
Error 10009: No Gurobi license found (user adeshmukh, host CALSPLADESHMUKH, hostid 1c5f7424, cores 4)
0 -
What do I have to do?
0 -
Gurobi cannot find a valid license file on your machine. I will open a support request for you so we can help you set up your license file properly.
0 -
Hi ,
I am also facing the same problem. How to solve it ?
0 -
Can you please post the details of the OpenSolver error message you see?
0 -
Note that the latest stable release of OpenSolver is 2.9.3 which was released over 4 years ago, which provided support for Gurobi v9.0.
Gurobi's latest release is v11.0.2 and we no longer provide support for v9.0, although it is still possible to download it from our website.
It is reasonable to assume that OpenSolver is no longer maintained and will slowly fade away into irrelevancy.
- Riley
0 -
Hi Riley,
If I were to install Gurobi v9.0 will I also need to get a license compatible with version 9.0 or will the version 11.0.2 also work If I were to use this for the Opensolver?
Thanks!
0 -
Hi Max,
License files are downward compatible and work with older Gurobi versions.
Best regards,
Marika0
Post is closed for comments.
Comments
15 comments