Solved

ExcelSetActiveSheet(data.xlsx, Sheet1) unable to get a handle to the workbook: Could not open Excel.

  • 16 December 2020
  • 2 replies
  • 84 views

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.

 

icon

Best answer by Gertjan 17 December 2020, 20:47

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

View original

2 replies

Userlevel 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

Reply


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

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