Error in dat file Exception from IBM ILOG Concert Excel range is unknown

Question

I write a 4D array data for my model, and now it show an error like the title. Anyone help me to fix it?

This is a part of the data file: dat file And this is the data file:

data demand data D&C

I try to find solution on internet but it not work

Answer 1

For 4D see read and write

But for your specific concern ( indirect) see

model:

{string} Variante=...;
int Station=...;
int AP=...;


 
float nb[1..AP,1..Station*card(Variante)]=...;


float b[s in Variante][m in 1..AP][p in 1..Station]=nb[m,1+ord(Variante,s)*Station+(p-1)];
 execute {
   writeln("b = ",b);
}; 

data:

SheetConnection sheet("3Dindirect.xlsx");
Variante from SheetRead(sheet,"data!B12:D12");
Station from SheetRead(sheet,"data!B8");
AP from SheetRead(sheet,"data!B9");

nb from SheetRead(sheet,"data!B4:J5");