Reading excel data

  • 31 March 2020
  • 4 replies



I have built my first AIMMS model and it is running without any errors now. However, it does not read my excel data and therefore I do not get any result. I was wondering what could be the problem. Do I need to save the project and the input excel sheet in the same folder?


Thank you very much in advance!



Best answer by Max Lomba Vrouenraets 7 April 2020, 10:18

View original

4 replies

Userlevel 5
Badge +2

Hi, @Max Lomba Vrouenraets . I can’t see in your code, where you are reading the values from the excel.

For instance, you can use some of these functions in order to read excel data:

AIMMS Functions to read Excel data


Hi @Max Lomba Vrouenraets 

Did mateus’s answer help you with your problem?



Hi @mateusarakawa,


First of all, thank you very much for your help! I truly appreciate it!


Nevertheless, AIMMS was not reading my excel sheet because I had not saved it in the proper folder. Once I changed the location of the document to the proper folder, AIMMS started reading the input data @Andrew.


Again, thank you!

I had problems at the beginning with XLSX. I think it has to be in XLS Filetype and not XLSX.


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

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