+1
While writing the suffices ProgramStatus and SolverStatus from a MathematicalProgram identifier to an Excel file using DEX I get numeric values rather than the lables indicated in this table:
Is there any way to write these labels rather than the corresponding numeric values?
Otherwise, where could I find the corresponding mapping between the numeric values and the labels (status) referred in the previous table?
Best answer by gdiepen
View original
+7
Not sure what code you are using to write the values, but one way you could force it to be a string is to use something like:
formatstring(“%e”, mpProblem.ProgramStatus)
+1
Thank you
I am using DEX to write the values into an Excel file. The code is the following:
<AimmsExcelMapping>
<ExcelSheetMapping name="Summary">
<RowMapping>
...
<ColumnMapping name="Program Status" maps-to="MathematicalProgram.ProgramStatus" />
<ColumnMapping name="Solver Status" maps-to="MathematicalProgram.SolverStatus" />
...
</ExcelSheetMapping>
</AimmsExcelMapping>Note that I believe I cannot use formatstring(“%e”, MathematicalProgram.ProgramStatus) in DEX
+7
What are the numbers that you see being written to Excel? Are those the ordinal values of these elements by any chance?
I think you might need somebody from AIMMS help out to really fix it (or provide the way it should work).
As a work-around, you could create two parameters:
spMathematicalProgramProgramStatus with definition formatstring(“%e”, MathematicalProgram.ProgramStatus)
spMathematicalProgramSolverStatus with definition formatstring(“%e”, MathematicalProgram.SolverStatus)
and write those two items to the excel file?
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages: