Originally posted by: trxw

Hello again..

Thanks to the community, I managed to finish the CPLEX model (using CP). What I want now is to be able to call the model from Excel as this is the user interface I am using. CPLEX should be able to read and write from/to the current (opened Excel worksheet). I read somewhere that the interface with excel (CPLEX___.xll) was discontinued at 12.6 or something like that so I tried doing it with the shell. The model runs but because I have the Excel opened it is not able to write there... Which are my options?

Another question is that I don´t really know how to get access to the different solutions found (it's a CP model). The way I do it now is by a time restriction (cp.param.timelimit=15;) but I what I really would like is to be able to export the solutions found (last 5 or something like that...)

Thanks in advance for your help

Hi,

in https://www.linkedin.com/pulse/how-opl-alex-fleischer/

you may have a look at

How to call OPL from Excel ?

and

How to enumerate all solutions ?

regards

Originally posted by: trxw

Great help as usual. Pitty that my skills do not allow me to go for the .NET creation and I should go through a shell. I will use another auxiliary file to export the results from CPLEX and then read them from the excel spreadsheet... Not the neatest solution but I think it will work!

Thanks