Skip to main content

How to use Gurobi in tandem with OpenSolver inside of Excel?

Answered

Comments

15 comments

  • Official comment
    Simranjit Kaur
    Gurobi Staff Gurobi Staff
    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?.
  • Greg Glockner
    Gurobi Staff Gurobi Staff

    I'm not aware of a way to call Gurobi from OpenSolver, but Solver Studio is a similar tool, and it supports Gurobi.

    0
  • Mario Viscardi Filho
    Gurobi-versary
    First Comment

    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
  • Ankur Deshmukh
    Gurobi-versary
    First Comment

    I am using opensolver. The model (simple one) provides optimized solution using CBC solver but the following error using gurobi.

    0
  • Eli Towle
    Gurobi Staff Gurobi Staff

    Could you please post the output you see when you click "More Details"?

    0
  • Ankur Deshmukh
    Gurobi-versary
    First Comment

    Hi, Thank you for your response.

    0
  • Eli Towle
    Gurobi Staff Gurobi Staff

    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
  • Ankur Deshmukh
    Gurobi-versary
    First Comment

    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
  • Ankur Deshmukh
    Gurobi-versary
    First Comment

    What do I have to do?

    0
  • Eli Towle
    Gurobi Staff Gurobi Staff

    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
  • Krishan Gupta
    First Question
    First Comment

    Hi ,

     

    I am also facing the same problem. How to solve it ?

    0
  • Eli Towle
    Gurobi Staff Gurobi Staff

    Can you please post the details of the OpenSolver error message you see?

    0
  • Riley Clement
    Gurobi Staff Gurobi Staff

    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
  • Max Berns
    First Comment

    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
  • Marika Karbstein
    Gurobi Staff Gurobi Staff

    Hi Max,

    License files are downward compatible and work with older Gurobi versions.

    Best regards,
    Marika

    0

Post is closed for comments.