Originally posted by: 2T3M_lolol

Hi,

After running the model, it has been shown that excel range is unkown......

could you tell me why is like that? in my programming it is like that 

what is wrong with it?

thank you 

Originally posted by: fbahr

The (work)sheets of check.xlsx are named 'Feuil*', not 'sheet*'.

  sheetConnection sheet("check.xlsx");
  m from SheetRead(sheet,"Feuil1!A1:PY441");

should do the trick.

--fbahr

Originally posted by: 2T3M_lolol

Oh! you are right!!!

Thank you so much fbahr!!!Thank you!

Originally posted by: CaWa

Hi 

I have unfortunately the same problem but I checked the names of the sheet and they should be right. Are there any other problems linked to "excel range unknown"?

SheetConnection InputExcel("InputData_Worker training.xlsx");

 maxS from SheetRead(InputExcel, "BC!B2");

Thank you in advance for your help!

Hi,

your .mod looks empty.

The name of your excel file is InputData.xlsx

But in your .dat you wrote

SheetConnection InputExcel("InputData_Worker training.xlsx");

which is different.

regards

Originally posted by: CaWa

Sorry, I uploaded the wrong zip-folder.

Both problems that you mentioned were already solved actually, but thanks!

Hopefully this is the right folder now!

I think there is something wrong with my Excel sheet but I really can't find the mistake.

Hi,

you should add

int maxS = ...;

in your .mod

In your .dat,

//Parameters

 

//wsn from SheetRead(InputExcel, "BC!B11:EU50");

 

trs from SheetRead(InputExcel, "BC!B53:AE92");

 

q from SheetRead(InputExcel, "BC!B95:EU169");

 

tu from SheetRead(InputExcel, "BC!BB172:BX191");

 

cufrom SheetRead(InputExcel, "BC!B194:U194");

 

tt from SheetRead(InputExcel, "BC!B197:AE271");

 

d from SheetRead(InputExcel, "BC!B274:BX274");

 

a from SheetRead(InputExcel, "BC!B276");

will work a little better.

But then you get an error because you have a size discrepancy in

 

tu from SheetRead(InputExcel, "BC!BB172:BX191");

You should fix that: tu has to have the same dimensions as BB172:BX191

regards

Originally posted by: CaWa

Thank you for your help.

It still tells me that there is an unknown Excel range.

Are there any other problems connected to the SheetRead function considering that the sizes of the matrices fit?

Hi,

well if you comment

//tu from SheetRead(InputExcel, "BC!BB172:BX191");

then you still have some errors but not excel ones

regards

Originally posted by: Breemes

Hi,

I have the same error code and cannot find the mistake. I use tuples and for all other variables it works fine, only here is problem:

string writeConnection5="Neu!A1:D";
execute
{
writeConnection5+=Wertstoffhof.UB*Handy.UB*ExternRecycling.UB;
}
int value5 [w in Wertstoffhof,i in Handy, e in ExternRecycling]=w*i*e;

 tuple Tuple5
  {
 int Handy;
 int Wertstoffhof;
 int ExtRecycling;
 int value5; };
 sorted {Tuple5} ZuordnungExtRecycling = {<w,i,e, ExternesRecycling [w][i][e]>|i in Handy, w in Wertstoffhof, e in ExternRecycling} ;
 

ZuordnungExtRecycling  to SheetWrite (output, writeConnection5);

Can anyone assist?

Thanks and regards,

Just a guess:

string writeConnection5="Neu!A1:D";

Don't you need number after 'D'?

Originally posted by: Breemes

Hi, 

i found the mistake, with the following advice:

I add  "writeln("writeConnection5 = " + writeConnection5);" to the execute part:

writeConnection5+=Wertstoffhof.UB*Handy.UB*ExternRecycling.UB;
}

  writeln("writeConnection5 = " + writeConnection5);

So you get an description of the error in the Scriptingprotocol. 

My mistake was, that the rows in Excel aren't enough -  I needed more than 1 million. 

Originally posted by: kmvenkat

I am trying out to connect excel sheet with prog 

but it shows " Excel Range is unknown " 

Code is as follows in dat file 

SheetConnection sheet("LargeScale3LocationModel.ods");
Warehouses from SheetRead(sheet,"City!D431:D630");  ( Error : Excel Range is unknown)
Customers from SheetRead(sheet,"'City'!E634:GV634");
MaxWarehousesP from SheetRead(sheet,"'City'!H212");
distance from SheetRead(sheet,"'City'!E431:GV630");
demand from SheetRead(sheet,"'City'!G11:G210");

Not sure how to clear this error . 

Hi,

this should work fine.

Do you run on windows ?

regards