Solved

spreadsheet::CreateWorkbook failed: Could not open Excel.

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

:sob: :sob: why

Best answer by mohansx

@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

Rewrite your procedure using AXLL functions instead of spreadsheet:: functions. https://how-to.aimms.com/Articles/85/85-using-axll-library.html
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

+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

Rewrite your procedure using AXLL functions instead of spreadsheet:: functions. https://how-to.aimms.com/Articles/85/85-using-axll-library.html
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

Mohan

@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

Rewrite your procedure using AXLL functions instead of spreadsheet:: functions. https://how-to.aimms.com/Articles/85/85-using-axll-library.html
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.

Sign up