Search found 5 matches
- 2 years ago
- Forum: Tools
- Topic: Importing Data From Excel
- Replies: 8
- Views: 11149
Re: Importing Data From Excel
Thanks a lot Michael
- 2 years ago
- Forum: Tools
- Topic: Importing Data From Excel
- Replies: 8
- Views: 11149
Re: Importing Data From Excel
Thank you Michael , It is Social Accounting Matrix and The excel file is large . I have posted a few rows and columns ( the rest is similar ) : ------------------- L L K K AG AG AG AG AG AG AG USK SK CAP LAND HRP HUP HRR HUR FIRM GVT L USK L SK K CAP K LAND AG HRP 5915 5078 526 1132 AG HUP 7300 4697...
- 2 years ago
- Forum: Tools
- Topic: Importing Data From Excel
- Replies: 8
- Views: 11149
Re: Importing Data From Excel
Dear Micheal , Sorry .I am not experienced with GAMS . -------------------------------------------------------------------------------- Input file : C:\Users\Sibetalaee\Documents\gamsdir\projdir\SAM.xls Output file: C:\Users\Sibetalaee\Documents\gamsdir\projdir\SAM.gdx **** There were 11 duplicate e...
- 2 years ago
- Forum: Tools
- Topic: Importing Data From Excel
- Replies: 8
- Views: 11149
Re: Importing Data From Excel
Dear Micheal , Here is the Log : --------------------------------------- *** GDXIN failed C:\Users\Sibetalaee\Documents\gamsdir\projdir\SAM.gdx *** Msg: No such file or directory --- sambal_2013Africa.gms(48) 3 Mb 1 Error *** Error 510 in C:\Users\Sibetalaee\Desktop\GAMS\iran\opensourceCGE\sambal\sa...
- 2 years ago
- Forum: Tools
- Topic: Importing Data From Excel
- Replies: 8
- Views: 11149
Importing Data From Excel
Hello ,
Thank you for your time
I am trying to import data from excel using the following code :
$CALL GDXXRW SAM.xlsx Par=SAM0 rng=A3:FM170
$GDXIN SAM.gdx
$LOAD SAM0
I recieve the Error 510 :" No such file or directory " .
I clearly see the file in my directory . Any advises ?
Thank you for your time
I am trying to import data from excel using the following code :
$CALL GDXXRW SAM.xlsx Par=SAM0 rng=A3:FM170
$GDXIN SAM.gdx
$LOAD SAM0
I recieve the Error 510 :" No such file or directory " .
I clearly see the file in my directory . Any advises ?