### Bad dimension error when using gdxxrw

Posted:

**Mon May 13, 2019 10:54 pm**Hi everyone,

I am having a "Symbol: ZIMSAM2 Bad dimension: 1" error when importing a parameter into GAMS from Excel. See the code below:

AC refers to every single variable in the model and ACP is an Alias for AC.

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!

Sarah

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!

Sarah