Read from Excel running in cluster environment
Posted: Thu Jul 11, 2019 6:07 pm
Hello,
I have a GAMS file that currently reads data from Excel. The way I have set this up is through the use of a .gpr so that the GAMS file can see the corresponing Excel one.
I want to run this now in a cluster environment, however there is no GUI for me to open the .gpr first and therefore GAMS doesn't see the corresponding Excel.
Does anyone know how to resolve this? Is there any way to code in the main GAMS file to open the .gpr first?
Thanks,
M
I have a GAMS file that currently reads data from Excel. The way I have set this up is through the use of a .gpr so that the GAMS file can see the corresponing Excel one.
I want to run this now in a cluster environment, however there is no GUI for me to open the .gpr first and therefore GAMS doesn't see the corresponding Excel.
Does anyone know how to resolve this? Is there any way to code in the main GAMS file to open the .gpr first?
Thanks,
M