Excel data exchange with GDXXRW

Problems with modeling
Post Reply
Danrome
User
User
Posts: 5
Joined: 5 years ago

Excel data exchange with GDXXRW

Post by Danrome »

Dear GAMS community,

I have a problem with the GDXXRW tool to import data from an Excel spreadsheet.
When i run the command $CALL GDXXRW....... i get the following errors:

Substituting Index
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many columns are ignored to form key for row
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
**** Too many rows are ignored to form key for column
Output gdx file deleted
Total time = 7984 Ms
--- data.gms(891) 3 Mb
*** GDXIN failed C:\Users\Daniele\Desktop\Analysis\data.gdx
*** Msg: No such file or directory

Any idea of why i get this error and how can i fix it.

Thank you very much, regards
Daniele
User avatar
bussieck
Moderator
Moderator
Posts: 1042
Joined: 7 years ago

Re: Excel data exchange with GDXXRW

Post by bussieck »

Provide your Excel workbook and the command line how you call gdxxrw and then there is a chance helping you here.

-Michael
Post Reply