Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  Extracting data from excel in OPL

    Posted 09/08/17 07:57 AM

    Originally posted by: K N Reddy


    Can I know how to extract data from excel into a 3 Dimensional Array in OPL??

     

    For example, X[i][j][k] is the input parameter for 2*2*2 dimensional array and A = [4 5 6 3; 7 8 9 5]

    I need to get X[2][1][1] = 7; 


    #CPLEXOptimizers
    #DecisionOptimization


  • 2.  Re: Extracting data from excel in OPL

    Posted 09/08/17 10:05 AM

    Hi,

    have you had a look at

    Reading a 3-dimensional array from an Excel spreadsheet

    http://www-01.ibm.com/support/docview.wss?uid=swg21401340

    ?

    regards


    #CPLEXOptimizers
    #DecisionOptimization