Skip to main content

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

:sob: :sob: why

 

@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

@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


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