Originally posted by: khadeejah

Hi all,

i want one of my variables solution to be displayed in excel , how can i do so

Hi,

you have an example in CPLEX_Studio127\opl\examples\opl\oil

in .mod

dvar float+ a[Gasolines];
dvar float+ Blend[Oils][Gasolines];

in .dat

a to SheetWrite(sheet,"RESULT!A2:A4");
Blend to SheetWrite(sheet,"RESULT!B2:D4");

regards

Originally posted by: khadeejah

Thanks Alex, i'll try it.

Originally posted by: khadeejah

I wrote: CHt to SheetWrite(sheet,"RESULT!A3:AV3");

but i had an error :

The sheet connection sheet is not defined

Hi,

have you written the SheetConnection part ?

oilSheet.dat:

SheetConnection sheet("oilSheet.xls");
Gasolines from SheetRead(sheet,"'gas data'!A2:A4");
Oils from SheetRead(sheet,"'oil data'!A2:A4");
Gas from SheetRead(sheet,"'gas data'!B2:E4");
Oil from SheetRead(sheet,"'oil data'!B2:E4");
MaxProduction = 14000;
ProdCost = 4;

a to SheetWrite(sheet,"RESULT!A2:A4");
Blend to SheetWrite(sheet,"RESULT!B2:D4");

regards

Originally posted by: khadeejah

i wrote the syntax in the .dat as follows:

SheetConnection sheet("results.xls");
CHt to SheetWrite(sheet,"results!A3:AV3");

but an error : file "results.xls" is not found.

What am i doing wrong.

P.s : all my solution is displayed normally in the solution tab, i just want one of the decision variable solution to be written in the excel directly.

Hi

the file result.xls should already exist.

OPL won t create it.

regards

Originally posted by: khadeejah

it exists already.

of course i created an excel and give it the name i put in the command