I have a 4-dimensional data in Excel as follows.
Row 1: Set a with 2 elements, /'Refinery 1','Refinery 2'/
Row 2: Set b with 2 elements, /'Pipeline','Rail'/
Column 1: Set q with 2 elements, /'Warehouse 1','Warehouse 2'/
Column 2: Set r with 3 elements, /'Petroleum','Diesel', 'Jet Fuel'/.
My data looks like this in Excel.
I try to import the data from Excel to GAMS by the following code.
sets a first row entries
b second row entries
q first column entries
r second column entries
parameter data3(a,b,q,r);
$CALL GDXXRW.EXE i=Try1.xlsx o=Try1.gdx set=a rng=Sheet1!A3:A6 rdim=1 set=b rng=Sheet1!B3:B6 rdim=1 set=q rng=Sheet1!C1:H1 cdim=1 set=r rng=Sheet1!C2:H2 cdim=1 par=data3 rng=Sheet1!A1:F6 Rdim=2 Cdim=2
$GDXIN Try1.gdx $LOAD a,b,q,r,data3 $GDXIN
display data3;
It shall produce the resulting parameter, i.e data3 as 24 elements (2x2x2x3), But it only shows 16 elements, due to some problems and ignores other elements.
The resulting GDX looks like this!
Any help will be highly appreciated. Thanks!