Originally posted by: Kei1

I have 720 data files (excel files) from which my model should read data and solve a single model.

I have searched the forum and all I have found are loops about reading data from a single excel file or changing cells/rows in one single excel file.

I would really appreciate it if you could help me with a loop  changing the data files and writing the objective value and cpu time.

Hi,

You will have to write 720 SheetConnection and SheetRead in the .dat so what I suggest is to generate this .dat through scripting.

And then you call this .dat in a main block.

See http://www-01.ibm.com/support/docview.wss?uid=swg21508158

for how to use IloOplOutputFile

regards

Originally posted by: Kei1

Well, changing the file manually by changing the name would be easier than writing 720 sheet connections.

Isn't there a way to do this without a person doing this tedious and time consuming things?

Hi,

yes the simpler way is to generate this .dat through scripting as I suggested.

regards

Originally posted by: Kei1

Would you kindly elaborate on this scripting you are referring to?