I am having a "Symbol: ZIMSAM2 Bad dimension: 1" error when importing a parameter into GAMS from Excel. See the code below:
Code: Select all
PARAMETER ZIMSAM2(AC, ACP) $call gdxxrw input="C:\Users\zimb_pan.xlsx" output="C:\Users\zimb_pan_sam.gdx" par=ZIMSAM2 rng=Sheet1!A1:AI35 rdim=1 cdim=1;
I understand that the error comes from cDim = 1 because when I increase cdim to a value x, the error message changes to Bad dimension:x.
Yet I know that labels are defined at column 1... So I am confused.
I joined the Excel file as an attachment.
Any help is appreciated!