Originally posted by: SerkanBayram

Hi !

I'm trying to write my OPL solution's in to a excel file. The problem is I don't know how to write the solutions certain field like A2:A4. 

Best Regards.   

This is the example of my code. 

execute{

var ocD = 0

for(var v in Vehicle){                                                    

           for(var p in Product){

              for (var j in DC){ 

                  for (var t in Period){   

                      ocD += OC[j]* DCb[v][p][j][t];

                }

              }

          }

       }        

      var f=new IloOplOutputFile("OPLResults.xls");      

      f.writeln("Order_Cost ",ocD);  

      f.close();

}

Hi

see

https://www.ibm.com/developerworks/community/forums/html/threadTopic?id=3fd44d41-210b-4b81-a005-819530d6377b&ps=25

but you could also use SheetWrite 

regards

ps:

many how to at https://www.linkedin.com/pulse/how-opl-alex-fleischer

Originally posted by: SerkanBayram

I can use SheetWrite function only in .dat files right ? 

Thank you so much Alex.

yes you re right.

SheetWrite works in .dat

regards