Help is needed with GDXXRW

GAMS
1

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?

2

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