I have one excel file with data that should be loaded in different variables, one scalar and one table. The only way I succeeded in reading them is by creating two .xls files with different names, and load data in different .gdx files.
This is not so elegant solution so I wanted to ask whether there is a solution to this issue, to read multiple data from same .xls file, either in same or separate gdx. Here is example:
Code: Select all
parameter p(r,c);
$CALL GDXXRW Curve.xlsx trace=3 par=p rng=Sheet1!a1:f97 rdim=1 cdim=1
$gdxin Curve.gdx
$load p
$gdxin
parameter h;
$CALL GDXXRW load.xlsx trace=3 par=h rng=Sheet1!i2:i2 dim=0
$GDXIN load.gdx
$LOAD h
$GDXIN
Thank you in advance,
Sanja