Originally posted by: NguyenHuuTRi

Hello,

In my model, the result returns three decision values, so I would very much appreciate it if you could show me how to export solutions/these value to excel automatically in CPLEX.

Thanks.

Tri.

Hi,

have you had a look at

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014419923

?

regards

Originally posted by: NguyenHuuTRi

Hello,

My question is that I have already the results as the post mentioned , let's say 4-dimensional array data. However, I wonder if we have anyway to export directly the results to excel instead that I have to copy all data sheet from CPLEX to excel?

Thanks.

Tri.

Hi,

once you have your tuple set you may use SheetWrite and then the tuple set will be written in the excel spreadsheet.

Regards 

Originally posted by: NguyenHuuTRi

Hi,

As I am a new beginner of CPLEX. Could you help me how to use syntax sheetwrite to the tuple set , let's say a four-dimensional array (xi,j,k,l) to excel?

Thanks so much.

Tri.

Hi,

let me give you a small example:

.mod

range I=1..3;
range J=1..5;
range K=1..6;
range L=1..3;

string writeConnection="A1:E";

execute
{
writeConnection+=I.UB*J.UB*K.UB*L.UB;
}

int x[i in I,j in J,k in K,l in L]=i*j*k*l;

subject to
{

}

tuple t
{
int i;
int j;
int k;
int l;
int x;
}

sorted {t} s={<i,j,k,l,x[i,j,k,l]> | i in I,j in J,k in K,l in L};

.dat

SheetConnection s("tutu.xlsx");

s to SheetWrite(s,writeConnection);

regards