Hi everyone,
I want to read my data from an Excel file in CPLEX but I want to write something like this:
forall (p in projects, q in activities, s in skills)
a[p][q][1] from SheetRead(my_sheet, "'Sheet1'!B36:K36")
Is there a way to do this or am I supposed to define every array element one by one?
Thank you in advance.
You can either create your LP as an .lp file or .mps file and then you can read it in the interactive version of CPLEX. For the Callable Library version, you can read data in a number of different ways. I would either create my own data file format and then read it in my C code, then create the LP using the Callable Library routines, orconvert my Excel file to .csv and again, programmatically read it from the csv file.
Dear Ekin Tanir,
Also i suggest you to see links and attached file on topic.
https://revealedpreferences.org/structure.html
Chapter Appendix A Coding Optimization Models in GAMS
Best regards
Leave data in excel sheet unconverted. you show PDF file extensions from CPLEX interface which is a powerful smart tool and can understand your requirements in standard office excel or word. you could also use ACCESS database - CPLEX interface communicates well with it.
- Badges
- Science topic
- Similar topics
- Linguistics
- Composition Studies
- Publication