Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
Back to discussions
Expand all | Collapse all

Write results to excel with multiple columns

  • 1.  Write results to excel with multiple columns

    Posted 01/19/16 10:24 AM

    Originally posted by: NguyenHuuTri


    Hi,

    I do not know how to write the results from decision variable x and y in my model to excel spreadsheet. I hope that you can help me to solve this problem.

    Thank you very much.

     

    Regards,


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: Write results to excel with multiple columns

    Posted 01/19/16 03:49 PM

    Hi

    you should have a look at

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

    in

    opl\examples\opl\oil

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


Related Content