Skip to main content

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

Ongoing

Comments

9 comments

  • 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
  • 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
  • Ankur Deshmukh
    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
    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
    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
    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

Please sign in to leave a comment.