Solved

Create project with Excel file

  • 26 March 2020
  • 3 replies
  • 80 views

Hello, 

I would like to create a project with AIMMS about transport problems. All my figures are in an excel table. How can I rearrange my table for use in AIMMS? 
I have successfully added the AIMMS tool to my Excel spreadsheet. 
Thank you in advance.

icon

Best answer by Jess Es 4 April 2020, 00:53

Hi @Steve Randy 

You may want to look at using the AIMMS Excel Library (axll) functions https://how-to.aimms.com/Articles/85/85-using-axll-library.html (also  https://how-to.aimms.com/Articles/197/197-reading-data-from-excel.html )

This should give you enough flexibility to read in the parts that you want to use without much rearranging.

I should note that I’m a docs specialist, not support specialist - but this should help you get started anyway :)

View original

3 replies

Thanks for your advices :) 

 

Userlevel 6

Hi @Steve Randy , the suggestion @Jess Es provides you allows you to , from AIMMS read data into your model and write back data to Excel. 
 

Userlevel 5

Hi @Steve Randy 

You may want to look at using the AIMMS Excel Library (axll) functions https://how-to.aimms.com/Articles/85/85-using-axll-library.html (also  https://how-to.aimms.com/Articles/197/197-reading-data-from-excel.html )

This should give you enough flexibility to read in the parts that you want to use without much rearranging.

I should note that I’m a docs specialist, not support specialist - but this should help you get started anyway :)

Reply


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

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