Hi
I am getting the following error while executing my code in AIMMS.
ExcelSetActiveSheet(data.xlsx, Sheet1) unable to get a handle to the workbook: Could not open Excel.
It would be grate if you can help me with this issue.
Best answer by Gertjan
View original
+6
Nowadays we have an AXLL library available that is better for reading (and writing) Excel files. This library does not require having Excel installed and can therefore also be deployed on server (such as AIMMS PRO).
I suggest to read article below on how to use this library. It is quite similar to the older functions (those are still there for now since not all our customers converted yet; however, we plan to announce a deprecation of them in 2021).
https://how-to.aimms.com/Articles/85/85-using-axll-library.html
Nowadays we have an AXLL library available that is better for reading (and writing) Excel files. This library does not require having Excel installed and can therefore also be deployed on server (such as AIMMS PRO).
I suggest to read article below on how to use this library. It is quite similar to the older functions (those are still there for now since not all our customers converted yet; however, we plan to announce a deprecation of them in 2021).
https://how-to.aimms.com/Articles/85/85-using-axll-library.html
thank you so much
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
