Hi! I would like to ask what this error means and how I can solve this:
ExcelRetrieveParameter(FINAL DATA.xlsx, nC(v,T,w), C3:ALN22, , 0) failed: The dimension of parameter "nC(v,T,w)" is 3. It must be equal to or smaller than 2.
I hope anyone can help me with this. Thank you!
Page 1 / 1
Hi, @pamjsnn .
Reading the Aimms function reference, the second argument of this excel function states that the parameter dimension can be 0, 1 or 2. In your case, parameter "nC" has 3 indexes {v,T,w}.
Thus, Spreadsheet::RetrieveParameter could only read a table with two indexes max., as shown below (Range "G6:N12"):
I think you should use Spreadsheet::RetrieveTable to read nC(v,T,w).
Reading the Aimms function reference, the second argument of this excel function states that the parameter dimension can be 0, 1 or 2. In your case, parameter "nC" has 3 indexes {v,T,w}.
Thus, Spreadsheet::RetrieveParameter could only read a table with two indexes max., as shown below (Range "G6:N12"):
I think you should use Spreadsheet::RetrieveTable to read nC(v,T,w).
Thank you! It worked!
Reply
Sign up
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.