Exporting CPLEX TSP example solution to csv/excel

Question

This might be a simple question but I have been struggling with this for a while.

I am using flow control to introduce lazy constraints when solving a problem that is very similar to a TSP. I found the CPLEX TSP example which I can follow well and use as a starting point to solve my problem.

Is there a way to export the solution of the CPLEX TSP example to a csv/excel sheet?

Answer 1

In Excel, Rocket science and optimization I shared an example

.mod

{int} solution=...;

.dat

SheetConnection s("travelingsalesman.xlsx");

solution to  SheetWrite(s,"output!B2:B1000");