Skip to main content
Solved

Read data Excel in an order

  • April 17, 2023
  • 2 replies
  • 72 views
M
Forum|alt.badge.img+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

Hello,

 

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,

Chris

2 replies

Chris Kuip
AIMMSian
Forum|alt.badge.img+7
  • Chris Kuip
  • AIMMSian
  • 125 replies
  • Answer
  • April 18, 2023

Hello,

 

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,

Chris

M
Forum|alt.badge.img+4
  • MZwanenburg
  • Author
  • 16 replies
  • April 24, 2023

Hi @Chris Kuip , 

It worked! Thank you very much for the example. 

 


Terms & ConditionsAccessibility statement

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

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