Skip to main content

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

Ongoing
Hannah Davis
Gurobi-versary
First Question

I'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!

Related to

0

Comments

9 comments

Date Votes
  • 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.

    2
  • 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.

Didn't find what you were looking for?

New post