Solved

spreadsheet::CreateWorkbook failed: Could not open Excel.

  • 24 March 2021
  • 2 replies
  • 82 views

Userlevel 1
Badge

spreadsheet::CreateWorkbook(results/Exercise_7/results_demands.xlsx,Energy_demands) failed: Could not open Excel.

:sob: :sob: why

 

icon

Best answer by mohansx 24 March 2021, 19:05

View original

2 replies

Userlevel 5
Badge +5

@xyr , that error occurs if you do not have Excel installed on the machine you are using AIMMS. Are you trying to run the model in a VM ?

 

You have two alternatives

  1. Rewrite your procedure using AXLL functions instead of spreadsheet:: functions. https://how-to.aimms.com/Articles/85/85-using-axll-library.html
  2. Read the Excel file on a machine with Excel installed on it, save a case file, use that case file to load data on the machine without Excel. See the Data menu in AIMMS.

Data → Save case as

Userlevel 1
Badge

@xyr , that error occurs if you do not have Excel installed on the machine you are using AIMMS. Are you trying to run the model in a VM ?

 

You have two alternatives

  1. Rewrite your procedure using AXLL functions instead of spreadsheet:: functions. https://how-to.aimms.com/Articles/85/85-using-axll-library.html
  2. Read the Excel file on a machine with Excel installed on it, save a case file, use that case file to load data on the machine without Excel. See the Data menu in AIMMS.

Data → Save case as

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