Search found 5 matches

by h.ehtesham
2 years ago
Forum: Tools
Topic: Importing Data From Excel
Replies: 8
Views: 10921

Re: Importing Data From Excel

Thanks a lot Michael
by h.ehtesham
2 years ago
Forum: Tools
Topic: Importing Data From Excel
Replies: 8
Views: 10921

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...
by h.ehtesham
2 years ago
Forum: Tools
Topic: Importing Data From Excel
Replies: 8
Views: 10921

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...
by h.ehtesham
2 years ago
Forum: Tools
Topic: Importing Data From Excel
Replies: 8
Views: 10921

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...
by h.ehtesham
2 years ago
Forum: Tools
Topic: Importing Data From Excel
Replies: 8
Views: 10921

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 ?