Include data in GAMS with an excel file
0
I want to include my data in GAMS with an excel file
$onecho > Dateninput.txt
set=i rng=Sets!A2 rdim=1
set=o rng=Sets!D2 rdim=1
set=k rng=Sets!G2 rdim=1
set=n rng=Sets!J2 rdim=1
set=t rng=Sets!M2 rdim=1
par=p rng=Parameter!A2:D10 cdim=1 rdim=1
par=d rng=Parameter!G2:J5 rdim=1 cdim=1
par=l rng=Parameter!B33:O58 rdim=2 cdim=2
par=ti rng=Parameter!A18 rdim=1
par=M rng=Parameter!G26 dim=0
par=h rng=Parameter!G17:J21 rdim=1 cdim=1
par=cap rng=Parameter!A26:D29 rdim=1 cdim=1
$offecho
$call gdxxrw i=Daten.xlsx o=inputs.gdx @Dateninput.txt
$GDXIN inputs.gdx
$LOAD i, o, k, n, t, p, d, ti, l, M, h, cap,
$gdxin
.....
execute_unload 'ergebnisse.gdx';
The 'inputs.gdx' file shows all sets and parameter. My output file 'ergebnisse.gdx'just shows me the sets and one dimention parameter but not the two dimention parameter. Could you please help me what I did wrong?
Thank you very much !
gams-math
asked Nov 14 '18 at 11:06
njbnjb
1
add a comment |
0
I want to include my data in GAMS with an excel file
$onecho > Dateninput.txt
set=i rng=Sets!A2 rdim=1
set=o rng=Sets!D2 rdim=1
set=k rng=Sets!G2 rdim=1
set=n rng=Sets!J2 rdim=1
set=t rng=Sets!M2 rdim=1
par=p rng=Parameter!A2:D10 cdim=1 rdim=1
par=d rng=Parameter!G2:J5 rdim=1 cdim=1
par=l rng=Parameter!B33:O58 rdim=2 cdim=2
par=ti rng=Parameter!A18 rdim=1
par=M rng=Parameter!G26 dim=0
par=h rng=Parameter!G17:J21 rdim=1 cdim=1
par=cap rng=Parameter!A26:D29 rdim=1 cdim=1
$offecho
$call gdxxrw i=Daten.xlsx o=inputs.gdx @Dateninput.txt
$GDXIN inputs.gdx
$LOAD i, o, k, n, t, p, d, ti, l, M, h, cap,
$gdxin
.....
execute_unload 'ergebnisse.gdx';
The 'inputs.gdx' file shows all sets and parameter. My output file 'ergebnisse.gdx'just shows me the sets and one dimention parameter but not the two dimention parameter. Could you please help me what I did wrong?
Thank you very much !
gams-math
asked Nov 14 '18 at 11:06
njbnjb
1
Hard to say, w/o being able to reproduce this. My guess would be a problem in the gdxxrw call. Do the 2-dim symbols in inputs.gdx actually have the expected data? Or are they empty? It could help if you run gdxxrw with the option "trace=3" and post the log.
– Lutz
Nov 14 '18 at 11:15
The inputs.gdx have the expected data. And the trace doesn´t work.
– njb
Nov 14 '18 at 12:34
add a comment |
0
0
0
I want to include my data in GAMS with an excel file
$onecho > Dateninput.txt
set=i rng=Sets!A2 rdim=1
set=o rng=Sets!D2 rdim=1
set=k rng=Sets!G2 rdim=1
set=n rng=Sets!J2 rdim=1
set=t rng=Sets!M2 rdim=1
par=p rng=Parameter!A2:D10 cdim=1 rdim=1
par=d rng=Parameter!G2:J5 rdim=1 cdim=1
par=l rng=Parameter!B33:O58 rdim=2 cdim=2
par=ti rng=Parameter!A18 rdim=1
par=M rng=Parameter!G26 dim=0
par=h rng=Parameter!G17:J21 rdim=1 cdim=1
par=cap rng=Parameter!A26:D29 rdim=1 cdim=1
$offecho
$call gdxxrw i=Daten.xlsx o=inputs.gdx @Dateninput.txt
$GDXIN inputs.gdx
$LOAD i, o, k, n, t, p, d, ti, l, M, h, cap,
$gdxin
.....
execute_unload 'ergebnisse.gdx';
The 'inputs.gdx' file shows all sets and parameter. My output file 'ergebnisse.gdx'just shows me the sets and one dimention parameter but not the two dimention parameter. Could you please help me what I did wrong?
Thank you very much !
gams-math
asked Nov 14 '18 at 11:06
njbnjb
1
I want to include my data in GAMS with an excel file
$onecho > Dateninput.txt
set=i rng=Sets!A2 rdim=1
set=o rng=Sets!D2 rdim=1
set=k rng=Sets!G2 rdim=1
set=n rng=Sets!J2 rdim=1
set=t rng=Sets!M2 rdim=1
par=p rng=Parameter!A2:D10 cdim=1 rdim=1
par=d rng=Parameter!G2:J5 rdim=1 cdim=1
par=l rng=Parameter!B33:O58 rdim=2 cdim=2
par=ti rng=Parameter!A18 rdim=1
par=M rng=Parameter!G26 dim=0
par=h rng=Parameter!G17:J21 rdim=1 cdim=1
par=cap rng=Parameter!A26:D29 rdim=1 cdim=1
$offecho
$call gdxxrw i=Daten.xlsx o=inputs.gdx @Dateninput.txt
$GDXIN inputs.gdx
$LOAD i, o, k, n, t, p, d, ti, l, M, h, cap,
$gdxin
.....
execute_unload 'ergebnisse.gdx';
The 'inputs.gdx' file shows all sets and parameter. My output file 'ergebnisse.gdx'just shows me the sets and one dimention parameter but not the two dimention parameter. Could you please help me what I did wrong?
Thank you very much !
gams-math
gams-math
asked Nov 14 '18 at 11:06
njbnjb
1
asked Nov 14 '18 at 11:06
njbnjb
1
asked Nov 14 '18 at 11:06
njbnjb
1
asked Nov 14 '18 at 11:06
njbnjb
1
asked Nov 14 '18 at 11:06
njbnjb
1
1
Hard to say, w/o being able to reproduce this. My guess would be a problem in the gdxxrw call. Do the 2-dim symbols in inputs.gdx actually have the expected data? Or are they empty? It could help if you run gdxxrw with the option "trace=3" and post the log.
– Lutz
Nov 14 '18 at 11:15
The inputs.gdx have the expected data. And the trace doesn´t work.
– njb
Nov 14 '18 at 12:34
add a comment |
Hard to say, w/o being able to reproduce this. My guess would be a problem in the gdxxrw call. Do the 2-dim symbols in inputs.gdx actually have the expected data? Or are they empty? It could help if you run gdxxrw with the option "trace=3" and post the log.
– Lutz
Nov 14 '18 at 11:15
The inputs.gdx have the expected data. And the trace doesn´t work.
– njb
Nov 14 '18 at 12:34
Hard to say, w/o being able to reproduce this. My guess would be a problem in the gdxxrw call. Do the 2-dim symbols in inputs.gdx actually have the expected data? Or are they empty? It could help if you run gdxxrw with the option "trace=3" and post the log.
– Lutz
Nov 14 '18 at 11:15
Hard to say, w/o being able to reproduce this. My guess would be a problem in the gdxxrw call. Do the 2-dim symbols in inputs.gdx actually have the expected data? Or are they empty? It could help if you run gdxxrw with the option "trace=3" and post the log.
– Lutz
Nov 14 '18 at 11:15
The inputs.gdx have the expected data. And the trace doesn´t work.
– njb
Nov 14 '18 at 12:34
The inputs.gdx have the expected data. And the trace doesn´t work.
– njb
Nov 14 '18 at 12:34
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53298763%2finclude-data-in-gams-with-an-excel-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53298763%2finclude-data-in-gams-with-an-excel-file%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hard to say, w/o being able to reproduce this. My guess would be a problem in the gdxxrw call. Do the 2-dim symbols in inputs.gdx actually have the expected data? Or are they empty? It could help if you run gdxxrw with the option "trace=3" and post the log.
– Lutz
Nov 14 '18 at 11:15
The inputs.gdx have the expected data. And the trace doesn´t work.
– njb
Nov 14 '18 at 12:34