Originally posted by: Hello76483
Hey,
I got a problem. I want to use one Excel file with different excel Sheets. They all look the same, except they contain different numbers. Now that I'm using a lot of sheets, I wanted to make opl automatically run all of the sheets, while solving the model for each sheet. I wanted to do it in the main, so I defined in the .mod file my variables:
string n = ...;
string s1 = ...;
string s2 = ...;
string dist = ...;
string yo = ...;
string zo = ...;
In the Main it looks like that:
main{
var ModelSource = new IloOplModelSource("Test.mod");
var ModelDefinition = new IloOplModelDefinition(ModelSource);
var ModelCplex = new IloCplex();
var Model = new IloOplModel(ModelDefinition,ModelCplex);
var ModelData = new IloOplDataSource("Test.dat");
Model.addDataSource(ModelData);
Model.generate();
ModelCplex.solve();
for(var i=0; i<50; i++){
var Model2 = new IloOplModel(ModelDefinition,ModelCplex);
var Dat = new IloOplDataElements();
Dat.n ="Tabelle" + i + "!A15:D26";
Dat.s1 = "Tabelle" + i + "!G17:J23";
Dat.s2 = "Tabelle"+ i + "!M17:P20";
Dat.dist = "Tabelle" + i + "!B62:X84";
Dat.yo = "Ergebnisse!B" + i + ":X"+ i;
Dat.zo = "Zielfunktion!A" + i;
Model2.addDataSource(Dat);
Model2.generate();
ModelCplex.solve();
Dat.end();
Model2.end();
}
ModelCplex.end();
ModelDefinition.end();
ModelSource.end();
}
But it's not generating my Model2. Does somebody know what's wrong with my code?
Thanks!
#DecisionOptimization#OPLusingCPLEXOptimizer