Decision Optimization

Decision Optimization

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

 View Only
Expand all | Collapse all

Read excel using tuples

  • 1.  Read excel using tuples

    Posted Mon November 06, 2017 01:04 AM

    Originally posted by: sandeepsinghchauhan


    I have a tuple

    tupleA
    {
    int a;
    }
    {A} A1 = ...;

     

    I have matrix a(rows)xb(columns)

     

      b(colums)    
    a(row) 1 2 3 4
    1 5 0 0 0
    2 0 2 0 0
    3 0 0 8 0
    4 15 0 0 9
    5 0 11 0 0

     

    How can I call this matrix from excel by using tuples only with the help of using A tuple. 

    Please help


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: Read excel using tuples

    Posted Mon November 06, 2017 04:57 AM

    Hi,

    why do not you read a 2D  array of int ?

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: Read excel using tuples

    Posted Mon November 06, 2017 05:00 AM

    Originally posted by: sandeepsinghchauhan


    That I can do but I dont want to use a new variable to read a data. Since I am using Tuple A so with the help of A I want to read my matrix


    #DecisionOptimization
    #OPLusingCPLEXOptimizer