Originally posted by: SystemAdmin

[jin82873053 said:]

hello

  i use OPL not for long,so i have much trouble

  now i want to add excel file into .dat file,but it is not going well

  error message: the sheet connection "sheet" is not defined.

  my code is:

  SheetConnection connex("mySheet.xls");
 
Products from SheetRead(sheet, "F6:F19");
Days from SheetRead(sheet, "G5:M5")

TESTCost from SheetRead(sheet, "B6:B19")
PgCost from SheetRead(sheet, "C6:C19")
HandCost from SheetRead(sheet, "D6:D19")

Finish from SheetRead(sheet, "N6:N19")

Worktime from SheetRead(sheet, "G21:M21")

Output to SheetWrite(sheet, "G6:M19")

I use MS office2003 and OPLIDE 6.0 version.


  this is my first time to come here, nice to meet u everyone here.

  and waiting for help^.^
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[oussedik said:]

Hi,

You need to define "sheet", and so replace connex by "sheet" in your code:

SheetConnection sheet("mySheet.xls");

Sofiane
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

[jin82873053 said:]

[quote author=Sofiane link=topic=674.msg2052#msg2052 date=1226248021]
Hi,

You...

Sofiane


It is very kind of you,Sofiane ^^  thank you very much.
#DecisionOptimization
#OPLusingCPLEXOptimizer