So I’m testing out running GAMS from a .bat (something simple).
“c:\Program Files\GAMS23.7\gams” BigModel.gms lo=2
The command starts but only gets to the following before hanging up.
It is creating the testbook.txt correctly and the .xls is in the same
directory as BigModel.gms.
— Starting compilation
— BigModel.gms(32) 2 Mb
— call =xls2gms @testbook.txt
I had a similar problem with another model and the Xldump command.
The model ran and created the .gdx but got the following. (note the
spreadsheet is not open so i assume is must be path related)…
GDXXRW Jul 14, 2011 23.7.3 WIN 27723.27726 VS8 x86/MS
Windows
Input file : C:\xampp\htdocs\xllink.gdx
Output file: C:\xampp\htdocs\OtherModel.xls
**** Problem opening Excel file: Microsoft Excel cannot access the
file ‘C:\xampp\htdocs\OtherModel.xls’. There are several possible
reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently
open workbook
Any help on setting paths or what might have caused this would be
greatly appreciated.
Ryan Cooper
\
I narrowed it down. It is very strange I can set up a .bat file that
works perfectly. with just this
xls2gms @testbook.txt
It creates a large number of .inc files that get included into my .gms
model.
I am trying to call this .bat from php using:
system(“test3.bat”);
When I do this I get no results.
I also have no luck what-so-ever with the $call command and xls2gms if
being called from php however I can call a .bat that has
gams bigmodel.gms lo=3
from php with no problem as long as xls2gms is not involved. Any help
on this would be very appreciated as i’m trying to do a proof of
concept. (it’s proving wrong currently).
On Feb 14, 10:23 am, Mr Cooper wrote:
So I’m testing out running GAMS from a .bat (something simple).
“c:\Program Files\GAMS23.7\gams” BigModel.gms lo=2
The command starts but only gets to the following before hanging up.
It is creating the testbook.txt correctly and the .xls is in the same
directory as BigModel.gms.
— Starting compilation
— BigModel.gms(32) 2 Mb
— call =xls2gms @testbook.txt
I had a similar problem with another model and the Xldump command.
The model ran and created the .gdx but got the following. (note the
spreadsheet is not open so i assume is must be path related)…
GDXXRW Jul 14, 2011 23.7.3 WIN 27723.27726 VS8 x86/MS
Windows
Input file : C:\xampp\htdocs\xllink.gdx
Output file: C:\xampp\htdocs\OtherModel.xls
**** Problem opening Excel file: Microsoft Excel cannot access the
file ‘C:\xampp\htdocs\OtherModel.xls’. There are several possible
reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently
open workbook
Any help on setting paths or what might have caused this would be
greatly appreciated.
Ryan Cooper
\