I have been doing some gams coding.
I declared Table on my gams, TIME(p,t)
TIME(p,t) means that if Person “P” is available at time “t”, value is “1” otherwise “0”.
TIME(p,t) is not variable, but table…
I would like TIME(p,t) to be exported and shown to Excel sheet.
so, I coded like this below.
===============================
execute_unload ‘TIME.gdx’
execute ‘gdxxrw.exe TIME.gdx’
execute ‘TIME.xlsx’ ;
but, There are no value on Excel sheet named TIME.
All of cell is blank…no data…
What and How should I modify on gams code?
I would appreciate it if you give me advices.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
Hi
Study the gdxutils manual and its examples, because your code clearly shows that you haven’t…
Cheers
Renger
sent from my iPad
Am 18.02.2014 um 09:28 schrieb “YOUNGKI CHOI” :
I have been doing some gams coding.
I declared Table on my gams, TIME(p,t)
TIME(p,t) means that if Person “P” is available at time “t”, value is “1” otherwise “0”.
TIME(p,t) is not variable, but table…
I would like TIME(p,t) to be exported and shown to Excel sheet.
so, I coded like this below.
===============================
execute_unload ‘TIME.gdx’
execute ‘gdxxrw.exe TIME.gdx’
execute ‘TIME.xlsx’ ;
but, There are no value on Excel sheet named TIME.
All of cell is blank…no data…
What and How should I modify on gams code?
I would appreciate it if you give me advices.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.
Hi! Renger,
I got it!
I read the manual you mentioned, and understand details!
I fixed my code like this…
execute_unload ‘TIME.gdx’, TIME
execute “gdxxrw TIME.gdx o=TIME.xlsx par=TIME”
execute ‘TIME.xlsx’
It works!
Thanks, Renger for your response!!
\
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/groups/opt_out.