Output su excel
Posted: Tue Jan 18, 2022 10:27 am
Hi everyone, I have a problem with the output of a result on an excel sheet. In practice I have x (s, i) as a result of the model and I would like me to output them on excel sheet only that I can't. The reason is that they are two indices? I am attaching a photo of the lst result of what to bring to excel.
solve portafoglio1 maximizing z using rmip;
display z.l, x.l;
execute_unload "PortfolioComp.gdx";
execute "gdxxrw PortfolioComp.gdx o=PorioComp.xls par=x rng=foglio1!a1 cdim=1 rdim=1 "
it just doesn't create any excel sheets for me. In the compiler it gives me this error message:
*** Keyword does not match symbol type, Symbol: x
Any changes made to the spreadsheet were not saved
could someone help me?
i try like this: solve portafoglio1 maximizing z using rmip;
display z.l, x.l;
execute_unload "PortfolioComp.gdx";
execute "gdxxrw PortfolioComp.gdx o=PorioComp.xls par=x rng=foglio1!a1 cdim=1 rdim=1 "
it just doesn't create any excel sheets for me. In the compiler it gives me this error message:
*** Keyword does not match symbol type, Symbol: x
Any changes made to the spreadsheet were not saved
could someone help me?