Originally posted by: SystemAdmin

Hi, everyone
I got a case that I have to run a loop to update the results after each iteration. As far as I know, OPL does not deal with the loop itself. In that case, I have to call some temporary stroage(for example Excel)in order to be called for next iteration.

Is there any method to deal with that problme? or say, is there any code enabling me to communicate with Excel??

Thanks very much!!
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

I don't think you need Excel to store your results from one iteration to the next,you can do loops and store information with ILOG Script. Check the documentation, in particular flow control scripts

If you believe you still need Microsoft Excel connectivity, check the example "oil" and the related documentation

Hope this helps
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Thanks very much. it is quite helpful.
#DecisionOptimization
#OPLusingCPLEXOptimizer