GAMS World Forum

Posted: **Fri Aug 31, 2018 6:31 am**

Hi
when we want to export parameter from GAMS to excel we write :

$call gdxxrw.exe results.xls par=Level rng=A1:D3

i have a scalar withe name " num_ca" , i want to export this scalar to excel , but h don't know how can i do that .

how can we export scalar from GAMS to excel ?

Best

Posted: **Fri Aug 31, 2018 11:08 am**

Hi Richard
Here an example in execution time:

Code: Select all

scalar b /2/;
execute_unload 'results.gdx', b
execute 'gdxxrw.exe i=results.gdx o=results.xls par=b rng=sheet!A1'

Hope this helps
Cheers
Renger

Posted: **Fri Aug 31, 2018 2:46 pm**

thanks

GAMS World Forum

Data Exchange with Microsoft Excel

Data Exchange with Microsoft Excel

Re: Data Exchange with Microsoft Excel

Re: Data Exchange with Microsoft Excel