Skip to main content

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.

 

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

Reply


Terms & Conditions

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

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