GDXXRWExample15.gms : Write spreadsheet using a filter

Description

The following example creates a small gdx file; the gdx file is used to write
the symbol A to a spreadsheet with the filter enabled


Category : GAMS Data Utilities library


Main file : GDXXRWExample15.gms   includes :  GDXXRWExample15.gms

$ontext
The following example creates a small gdx file; the gdx file is used to write
the symbol A to a spreadsheet with the filter enabled
$offtext

$if %system.filesys% == UNIX $abort.noerror 'This model cannot run on a non-Windows platform';
$call msappavail -Excel
$if errorlevel 1 $abort.noerror 'Microsoft Excel is not 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.exe test.gdx filter=1 par=A rdim=1 cdim=2 rng=sheet1!a1 trace=0';