Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only

  • 1.  How to read a tuple from excel on cplex

    Posted 08/19/20 03:36 PM
    Hi ;
    How can I read a tuple from excel on cplex . i tried to name the ranges on excel but it doesn't work, please what am i doing wrong here:
    /* .mod file*/
    tuple Operation { 
    int id;
    int jobId;
    int pos; };

    /*.data file*/
    SheetConnection datasheet("dataCPbro.xlsx");
    Ops from SheetRead (datasheet,"'data1'!Opstuple");

    "Opstuple" (8 rows and 3 coloumns) defined in "dataCPbro.xlsx" file:


    ------------------------------
    So jana
    ------------------------------

    #DecisionOptimization


  • 2.  RE: How to read a tuple from excel on cplex
    Best Answer

    Posted 08/20/20 12:45 AM
    Edited by System Admin 01/20/23 04:14 PM

    Hi

    if Opstuple is your named range you should write

    Ops from SheetRead (datasheet,"Opstuple");

    instead of 

    Ops from SheetRead (datasheet,"'data1'!Opstuple");


    regards

    PS:

    Simple complete example at https://github.com/AlexFleischerParis/zooopl/blob/master/zooexcel.mod



    ------------------------------
    ALEX FLEISCHER
    ------------------------------



  • 3.  RE: How to read a tuple from excel on cplex

    Posted 08/20/20 03:01 AM
    Hi Alex;
    I tried this : Ops from SheetRead (datasheet,"Opstuple"); but i get this error:

    Exception dans pré-résolution : Interval sequence variable 'mchs(3)': interval variable 'modes({3,2,3,1,40})' appears more than once in the sequence.

    I don't know what iam doing wrong

    Regards

    ------------------------------
    So jana
    ------------------------------

    Original Message


  • 4.  RE: How to read a tuple from excel on cplex

    Posted 08/20/20 03:27 AM
    Edited by System Admin 01/20/23 04:16 PM

    ------------------------------
    So jana
    ------------------------------


    Original Message


  • 5.  RE: How to read a tuple from excel on cplex

    Posted 08/20/20 03:30 AM
    Hi,

    this means you moved forward since now you do not have issues with reading but with presolve.
    The same interval should not be several times in the sequence.

    regards

    ------------------------------
    ALEX FLEISCHER
    ------------------------------

    Original Message


  • 6.  RE: How to read a tuple from excel on cplex

    Posted 08/20/20 03:51 AM
    Thank you alex , but i have no idea what i'm doing wrong . Could you help me with this please. i've attached the .mod file and the data one.

    Thank you

    Regards



    ------------------------------
    So jana
    ------------------------------

    Original Message


  • 7.  RE: How to read a tuple from excel on cplex

    Posted 08/20/20 04:04 AM
    Thank you Alex . I resolved the error i  did a mistake in my data  declaration .

    Have a good day

    Best regards

    ------------------------------
    So jana
    ------------------------------

    Original Message


Related Content