Good morning.
I have a problem when extracting data for the variables from excel, it automatically shows me the following message:
“Excel version 16.0
Input file : C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\ensayo.xlsx
Output file: C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\ensayo.GDX
**** Symbol: i Bad dimension: 1;
Total time = 718 Ms
— Excel.gms(28) 3 Mb[FIL:“C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms”,28,0]
*** GDXIN failed C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\ensayo.gdx
*** Msg: No such file or directory
— Excel.gms(28) 3 Mb 1 Error[FIL:“C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms”,28,0]
*** Error 510 in C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms[ERR:“C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms”,28,17][LST:24]
Unable to open gdx file for $GDXIN
— Excel.gms(29) 3 Mb 2 Errors[FIL:“C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms”,29,0]
*** Error 502 in C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms[ERR:“C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms”,29,5][LST:27]
GDXIN file not open - ignore rest of line
— Excel.gms(32) 3 Mb 2 Errors[FIL:“C:\Users\Nuevo Usuario\Documents\gamsdir\projdir\Excel.gms”,32,0]
*** Status: Compilation error(s)[LST:58]
— Job Excel.gms Stop 05/26/23 14:42:52 elapsed 0:00:00.953”
I have tried all the ways and I don’t know what to do, I feel that I am stuck.
Excel.gms (751 Bytes)
ensayo.xlsx (13.5 KB)