I tried to follow the tutorial to read the data from excel. I have manually inserted the data for the sets of the index c,t and r in AIMMS. Then, I must set a 3-dimensional parameter, e.g. waste(c,t,r) as shown in the picture below. I wish to insert the data for the parameter by using the axll function in AIMMS.
I put the excel sheet in the AMMS data folder. I tried using this coding:
WorkBookName := "roomWaste.xlsx";
if axll::WorkBookIsOpen(WorkBookName) then
axll::SelectSheet(SheetName : "Waste");
IdentifierReference : waste(c,t,r),
RowHeaderRange : "A5:A2890",
ColumnHeaderRange : "B2:KLH3",
DataRange : "B5:KLH2890");
However, when i tried to run the procedure, there is warning/error as shown below:
Can anyone help me with this problem? Thank you in advance!
Best answer by mohansxView original
If your file is in the data folder, then the path must be “data//roomWaste.xlsx”
It works! Thank you