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.
Best answer by Jess Es
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 :)
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.
Thanks for your advices :)
Already have an account? Login Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
Didn't find what you were looking for? Try searching on our documentation pages:
AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator