Solved

Reading excel data

  • 31 March 2020
  • 4 replies
  • 120 views

Hi,

 

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!

 

icon

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

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!

View original

4 replies

Userlevel 5

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?

 

Thanks

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.

Reply


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

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