Data Exchange with Microsoft Excel

GAMS
1

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

2

Hi Richard
Here an example in execution time:

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

3

thanks