Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.

 View Only
Expand all | Collapse all

How to write results into excel in postprocessing

  • 1.  How to write results into excel in postprocessing

    Posted Sat December 31, 2011 08:27 AM

    Originally posted by: GACNEU


    hello everybody
    can someone show me a simple example?
    thanks a lot!!
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: How to write results into excel in postprocessing

    Posted Mon January 02, 2012 02:06 AM
    Hi,

    in CPLEX_Studio124\opl\examples\opl\oil

    you can have a look at oilSheet.dat

    where you will see

    a to SheetWrite(sheet,"RESULT!A2:A4");
    Blend to SheetWrite(sheet,"RESULT!B2:D4");
    


    SheetWrite writes results into an excel sheet

    Regards
    #DecisionOptimization
    #OPLusingCPLEXOptimizer