The codes below turns all my data into "1.000". Please help.
$CALL GDXXRW.EXE Nigeria_data.xlsx par=tyyz rng=sheet2!a1..k10
$GDXIN Nigeria_data.gdx
$LOADDC tyyz
$GDXIN
;
excel to gams Topic is solved
Re: excel to gams
Hello group.
I can print date and hour of GAMS execution in TXT. But I need print date and hour of GAMS execution in excel.
Does anyone know a syntax to print date and hour ejecution in excel?
Best regards
I can print date and hour of GAMS execution in TXT. But I need print date and hour of GAMS execution in excel.
Does anyone know a syntax to print date and hour ejecution in excel?
Best regards
Re: excel to 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
-Michael
Code: Select all
scalar x; x = jnow;
execute_unload 'time', x;
execute 'gdxxrw time.gdx o=time.xlsx par=x rng=a1';
-Michael