Decision Optimization

Decision Optimization

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

 View Only
Expand all | Collapse all

Exception from IBM ILOG Concert: excel: range has a bad size. it must be only 1 line or 1 row

  • 1.  Exception from IBM ILOG Concert: excel: range has a bad size. it must be only 1 line or 1 row

    Posted Tue November 17, 2020 12:07 PM

    How can I solve this error? (There is no specific location given)

    "Exception from IBM ILOG Concert: excel: range has a bad size. it must be only 1 line or 1 row."

    I read my data from Excel. I already wrote my whole code while sheetreading matrices with multiple rows or columns. Never had a problem, now all of a sudden, this pops up as a problem. The last piece of code I did was this

    forall (d in decisions, o in orders, p in pieces, m in modes) (varcost[d] == (sum (o in orders, p in pieces, m in modes) volume[o]*cvarcalm[m]*distance[p]*z[d,o,p,m]));
    

    so my best guess is that this has something to do with it.

    You can find my full code here:

    https://1drv.ms/w/s!AmJYk6YmU7wu7RgwYjV9U-CqAF-d?e=B9hqbV



    ------------------------------
    Mathias De Backer
    ------------------------------

    #DecisionOptimization


  • 2.  RE: Exception from IBM ILOG Concert: excel: range has a bad size. it must be only 1 line or 1 row

    Posted Tue November 17, 2020 02:45 PM

    Hi

    as I wrote in

    https://stackoverflow.com/questions/64845630/exception-from-ibm-ilog-concert-excel-range-has-a-bad-size-it-must-be-only-1/64856480?r=SearchResults#64856480

    can you attach all files so that Other Users could try ?



    ------------------------------
    [Alex] [Fleischer]
    [EMEA CPLEX Optimization Technical Sales]
    [IBM]
    ------------------------------