Originally posted by: giannil

Hello,

How can you import data from an excel-sheet to cplex? What is the easiest way?

Thanks

Originally posted by: GGR

Hi Gianni

You can load the data for an OPL Studio model from an Excell spreadhit.

If You think specifically to the CPlex solver, please send tour request to the  Mathematical Programming\Cplex Optimizer forum

Hope that helps

Originally posted by: giannil

Is it possible to give a link where they give an example. An example where they show how to load things from excel into cplex?

Thanks for your answer already!

Originally posted by: GGR

Hi Gianni

For OPL studio, there is some samples in this entry

Hope that helps

Originally posted by: giannil

Hello,

We tried to connect to an excel file but Cplex doesn't find the excel file. 

This is our datafile : 

SheetConnection sheet("Bewerkte Data.xlsx");

AantalFG = 84;
AantalPodia = 2;
AantalTijdsblokken = 3;
AantalArtiesten = 6;

Voorkeuren from SheetRead(sheet,"Tomorrowland!B2:G85");

Why doesn't cplex find the file?

In attachments you will find the excelfile

Thanks‹

Originally posted by: ArnaudS

Hello,

Hope this helps,

Arnaud

Originally posted by: giannil

Hello,

in attachment you can find our project file

Thanks

Originally posted by: giannil

We managed to do it. Thank you for your help!