Solved

Export the AIMMS file to Excel

  • 29 April 2024
  • 1 reply
  • 28 views

Hi guys,

 

I’m a student from the university of HEC in Belgium and I need your help for one project that I’m working on for one of my courses.

 

In fact, I have received a database from Excel that I have exported on AIMMS (which has been done succesfully). Then I’ve realized my parameters, constraints, … in order to optimize the function that the teacher gave to us.

 

But now, the teacher expects to us to export the AIMMS file to Excel to realize our analysis (so once all the values have been computed, we have to export these numbers to Excel in order to analyze these numbers) and I don’t understand how can I export the AIMMS file to the Excel.

 

Can you please, try to help me?

 

Thanks for the answers :)

icon

Best answer by gdiepen 29 April 2024, 22:16

View original

1 reply

Userlevel 5
Badge +7

You will have to use something like the AXLL library and some AIMMS code to write the contents of specific parameters / variables to ranges on sheets.

 

You can find some more information/examples via the following links:

 

Depending on the type of output needed, you can also use the aimms Data Exchange (DEX) library for output to excel.

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator