unable to read excel data in gams

GAMS
1

Hi everyone,
my gams model could not read the data from the excel file.Even call keyword is not recognized.For simplicity,These two lines are written here

sets t /1*668/;
$call gdxxrw.exe rate.xlsx Par=Pbi rng=data!G1:H668 rdim=1 cdim=0

Compilation error:looking for a ; or a keyword to get started.

excel file attached herewith is saved in the same directory.

–
rate.xlsx (15.9 KB)

2

Hi
The dollar sign should be in the first column (true for every $-command of gams)
Cheers
Renger

sent from my iPad

On 06 Apr 2015, at 14:02, “shpooja26@gmail.com” wrote:

Hi everyone,
my gams model could not read the data from the excel file.Even call keyword is not recognized.For simplicity,These two lines are written here

sets t /1*668/;
$call gdxxrw.exe rate.xlsx Par=Pbi rng=data!G1:H668 rdim=1 cdim=0

Compilation error:looking for a ; or a keyword to get started.

excel file attached herewith is saved in the same directory.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.

3

Thank you very much for pointing out the mistake.Program is getting compiled.Thanks to you

On Monday, April 6, 2015 at 5:32:46 PM UTC+5:30, shpo...@gmail.com wrote:

Hi everyone,
my gams model could not read the data from the excel file.Even call keyword is not recognized.For simplicity,These two lines are written here

sets t /1*668/;
$call gdxxrw.exe rate.xlsx Par=Pbi rng=data!G1:H668 rdim=1 cdim=0

Compilation error:looking for a ; or a keyword to get started.

excel file attached herewith is saved in the same directory.

–
To unsubscribe from this group and stop receiving emails from it, send an email to gamsworld+unsubscribe@googlegroups.com.
To post to this group, send email to gamsworld@googlegroups.com.
Visit this group at http://groups.google.com/group/gamsworld.
For more options, visit https://groups.google.com/d/optout.