GDXXRWExample15.gms : Writing to Spreadsheet using a Filter

Description

The following example creates a small GDX file which is used to write
the symbol A to a spreadsheet with the filter enabled.

This model is referenced in "Writing Spreadsheet using a Filter" from
the GDXXRW Documentation.


Category : GAMS Data Utilities library


Main file : GDXXRWExample15.gms   includes :  GDXXRWExample15.gms

$title Writing to Spreadsheet using a Filter (GDXXRWExample15,SEQ=076)

$onText
The following example creates a small GDX file which is used to write
the symbol A to a spreadsheet with the filter enabled.

This model is referenced in "Writing Spreadsheet using a Filter" from
the GDXXRW Documentation.
$offText

$callTool win32.msappavail Excel
$if errorlevel 1 $abort.noError "No Excel available"


Set
   i / i1*i2 /
   j / j1*j2 /
   k / k1*k2 /;

Parameter A(i,j,k);
A(i,j,k) = uniform(0,1);

execute_unload 'test.gdx', A;
execute 'gdxxrw test.gdx filter=2 par=A rDim=1 cDim=2 rng=sheet1!A1 trace=0';