Thursday, July 24, 2008

gdx2xls does not work with 22.7

> Erwin. When tried to create xls file from gdx, I got an error message (see log file).
>*** Error at line 7379: Execute has nonzero return code RC=2

The GDX API has been changed between 22.5 and 22.6. You hare using 22.7 and your version of gdx2xls for <= 22.5. A work around is:


scalar s /3.14/;
execute_unload "s.gdx",s;
execute '=gdxcopy -v6c s.gdx oldgdx';
execute '=gdx2xls oldgdx\s.gdx';
execute '=shellexecute oldgdx\s.xls';.

This should show:
--- Job Untitled_39.gms Start 07/24/08 18:17:48
GAMS Rev 227 Copyright (C) 1987-2008 GAMS Development. All rights reserved
Licensee: Erwin Kalvelagen G070509/0001CE-WIN
GAMS Development Corporation DC4572
--- Starting compilation
--- Untitled_39.gms(9) 2 Mb
--- Starting execution: elapsed 0:00:00.003
--- Untitled_39.gms(7) 3 Mb
Writing files to: .\.\oldgdx
Converting file: .\s.gdx
--- Untitled_39.gms(8) 3 Mb
GDX2XLS Version 3.0
Reading GDX file oldgdx\s.gdx
Reading 1 symbols, sorting: 0.00 seconds
Reading 0 UELs: 0.00 seconds
Opening C:\projects\test\oldgdx\s.XLS with Excel: 0.31 seconds
s. To scalar sheet
Total elapsed time: 0.72 seconds
--- Untitled_39.gms(9) 3 Mb
Shell Execute May 1, 2008 22.7.2 WIN 3727.4799 VIS x86/MS Windows
--- Untitled_39.gms(9) 3 Mb
*** Status: Normal completion
--- Job Untitled_39.gms Stop 07/24/08 18:19:49 elapsed 0:02:00.857


Update: unfortunately this worked for me, but not for the user. I don't understand why. Contact support@gams.com and ask for a 22.7 version of gdx2xls.exe.