The codes below turns all my data into "1.000". Please help.
$CALL GDXXRW.EXE Nigeria_data.xlsx par=tyyz rng=sheet2!a1..k10
Problems with syntax of GAMS
GAMS and Excel (and many other program work with the Julian date or serial date, a single number represents date and time). Just write this number to Excel and format as date:
There are function to go from serial dates to regular calendar dates and vice versa: https://www.gams.com/latest/docs/UG_Par ... rFunctions
Code: Select all
scalar x; x = jnow; execute_unload 'time', x; execute 'gdxxrw time.gdx o=time.xlsx par=x rng=a1';