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:
Sent: Thu August 20, 2020 03:26 AM
From: So jana
Subject: How to read a tuple from excel on cplex
To be more clear, here are my files:
------------------------------
So jana
Original Message:
Sent: Thu August 20, 2020 03:01 AM
From: So jana
Subject: How to read a tuple from excel on cplex
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:
Sent: Thu August 20, 2020 12:44 AM
From: ALEX FLEISCHER
Subject: How to read a tuple from excel on cplex
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
Original Message:
Sent: Wed August 19, 2020 11:17 AM
From: So jana
Subject: How to read a tuple from excel on cplex
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