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.
- I can only use .xls file - it doesn’t work with .xlsx.
- 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