Help is needed with GDXXRW

Problems with syntax of GAMS
Post Reply
parag_patil
User
User
Posts: 30
Joined: 2 years ago
Location: Ahmedabad
Contact:

Help is needed with GDXXRW

Post by parag_patil »

Hello,

I have multiple parameters to be imported from excel sheet. Currently, I am using multiple $call gdxxrw as follows:

$call GDXXRW o=scold.gdx i=input_data.xlsx trace=3 set=scold rng= set_vert_streams!g2 rdim=1
$call GDXXRW o=shot.gdx i=input_data.xlsx trace=3 set=shot rng= set_vert_streams!h2 rdim=1


can I combine above and make the script shorter?
User avatar
bussieck
Moderator
Moderator
Posts: 1033
Joined: 7 years ago

Re: Help is needed with GDXXRW

Post by bussieck »

You find this in the GDXXRW documentation (https://www.gams.com/latest/docs/T_GDXXRW.html). It is a little hidden. Search the page for "An option file is indicated by preceding the file name with a @ (At sign.).".

-Michael
Post Reply