Read data Excel in an order

  • 17 April 2023
  • 2 replies

Badge +4

Hi all, 

I want to read data from Excel but it should be sorted customly. 

In Excel the data is like this: 


The result in AIMMS should be this: 


I can create this with a text join in Excel and paste the value in the data field in AIMMS but the data changes frequently so I want to automate this with AXLL functions. It is important that the order of a, b and c holds. 


Does anyone have an idea to do this? 


Best answer by Chris Kuip 18 April 2023, 16:56

View original

2 replies

Badge +4

Hi @Chris Kuip , 

It worked! Thank you very much for the example. 


Userlevel 5
Badge +7



After reading in the second column into a string parameter, I'd use the following steps:

  • For each row:

I've enclosed a small working AIMMS 4.94 project.


Let me know if you have questions on the above.


With kind regards,



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

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