GDXXRW issues

questions about GAMS' tools
Post Reply
Nish
User
User
Posts: 1
Joined: 7 years ago

GDXXRW issues

Post by Nish »

Hi All

I am having a couple of issues with GDXXRW - both while importing and exporting files from Excel.
I have Excel 2010 and the latest version of GAMS.

1. I can only use .xls file - it doesn't work with .xlsx.
2. When I write to Excel, I have to create a new file every time. It does not work if the file existed already, even if is closed.
This is my code:
Execute 'GDXXRW.EXE report.gdx O=report1.xls par=bau rng=Sheet1!a1 cdim=0 ';

Have any of you come across these issues before?

Thanks

Nishaal
User avatar
bussieck
Moderator
Moderator
Posts: 1033
Joined: 7 years ago

Re: GDXXRW issues

Post by bussieck »

What version of GAMS do you use, what is the error message?

-Michael
Post Reply