Hello,
I want to transfer the result of my model to excel. I used below options;
execute_unload "result_model1acost.gdx"
execute 'gdxxrw.exe result_model1acost.gdx
In additon, I want to add description of the result in my excel file.
For example;
(NOTE: I atteched my result excel file)
Above numbers show result of UATS(k) value (Average amount of TS produced in k blood donation center)
01011 01312 06712 16162 16774 21721 21212 81543 81415
532,53 2539,35 219,01 4433,22 626,175 490,93 1874,62 1605,615 91,095
I want to write "UATS(k) value (Average amount of TS produced in k blood donation center)" to A2 cell of UATS page in my excel file.
So, which option or code can I use to add the same words to the excel file.
Could you help me please?
Best Regards
Vahdi
output the results to excel
output the results to excel
- Attachments
-
- result_model1acost.xlsx
- (99.48 KiB) Downloaded 274 times
Re: output the results to excel
Hi Vahdi
You will find the answer in the first example of the GDXXRW documentation.
Cheers
Renger
You will find the answer in the first example of the GDXXRW documentation.
Cheers
Renger
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist
Enjoy modeling even more: Read my blog on modeling at The lazy economist