Hi! I encountered this problem as I try to recall my data from an excel file.
The error says: ExcelRetrieveParameter(FINAL DATA.xlsx, N(E), B16:DQ16, , 0) failed: Actual cardinality (0) of domain #1 is smaller than specified cardinality (120).
what should I do?
Page 1 / 1
Hi @pamjsnn .
I think your set, which has "E" as index, is empty.
Therefore, AIMMS can't link the excel table index to your set elements.
If you want to automatically populate your set, I would try Spreadsheet::RetrieveTable with argument "AutomaticallyExtendSets" : 1.
I think your set, which has "E" as index, is empty.
Therefore, AIMMS can't link the excel table index to your set elements.
If you want to automatically populate your set, I would try Spreadsheet::RetrieveTable with argument "AutomaticallyExtendSets" : 1.
It worked! Thank you sooo much
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.