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,