Originally posted by: monsieursoif

Hi,

I'm trying to read data from an excel spreadsheet and I've been getting an internal error since I implemented the connection.

my .mod-file:

 int varm = ...;
 int varn = ...;
 {int} legs = asSet(0..varm-1);
 {int} odpairs = asSet(0..varn-1);
 int capacity[legs] = ...;
 float rate[odpairs] = ...;
 int meandemand[odpairs] = ...;
 int lowerb[odpairs] = ...;
 int upperb[odpairs] = ...;
 int interval[legs][odpairs];

my .dat-file:

 SheetConnection data("data.xlsx")
 varm = 5;
 varn = 15;
 capacity from SheetRead (data, "capacityS1");
 rate from SheetRead (data, "ratesS1");
 meandemand from SheetRead (data, "demandS1");
 lowerb from SheetRead (data, "lowerbS1");
 upperb from SheetRead (data, "upperbS1");

I'm pretty sure I named all the ranges in excel correctly and I really don't have a clue what goes wrong there. I will include my excel-file as an attachment although I'm almost sure the problem doesn't lie there.

Thank you in advance for your help!

soif

Hi,

which cplex version do you use ?

Can you try to change

SheetConnection data("data.xlsx")

into

SheetConnection data("data.xlsx");

?

regards

Originally posted by: monsieursoif

thank you for your quick response!

I'm using the version 12.9.0.0. While the missing semicolon definetely was an error it didn't help the internal error I'm having.

regards

Hi

on my machine this works fine

just to be sure you have excel on your machine ?

regards

Originally posted by: monsieursoif

I do have excel on my laptop and the sheet seems correctly located as it is displayed on the left side in the OPL-Project overview. It has to do with my configuration of CPLEX then I'd guess but I just downloaded and started using it so as far as I know I did not change any of the settings there.

I even reinstalled CPLEX Studio now and it still results in the same error message.

Hi,

and you run on windows ?

regards

Originally posted by: monsieursoif

yes I'm running Windows 10 and Excel in the Microsoft Office 365 ProPlus subscription.