How can I write the values of a decision variable to an Excel sheet after running an iterative optimization in CPLEX OPL?

Question

I am performing an iterative optimization using the main function in CPLEX OPL. After each iteration, I want to write the values of the decision variables to an Excel sheet. The optimization runs for 100 iterations, and the variable x has a size of 100×96 (i.e., x[1..100][1..96]). While I am writing the variable values to an Excel sheet, I noticed that the values from the last iteration are not being saved. Currently, I am using a .dat file for this process. How can I ensure the values from all iterations, including the final one, are correctly written to Excel?

Please include an minimal reproducible example to help readers to answer your question. — Black cat
– Black cat, Commented Mar 28 at 11:14

Alex Fleischer · Accepted Answer · 2025-03-29 15:27:29Z

0

If the values from the last iteration are not saved and the previous ones are, and if you use SheetWrite to write results into excel, then in your main loop you should check that you call postProcess for the last iteration.

answered Mar 29 at 15:27

Alex Fleischer

10.3k2 gold badges14 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I write the values of a decision variable to an Excel sheet after running an iterative optimization in CPLEX OPL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related