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
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).